Note: The name “SmartConnector” will be changing to the “Integration App” to more clearly establish that our pre-built Integration Apps are built on our flagship Integration Platform as a Service, integrator.io.
The connector generally doesn't support mapping between multi-select fields but as a possible workaround, a NetSuite formula field can be created that contains all the selected values as a text string. The formula field would then be chosen as the mapping source.
For this example, it is assumed that the field's internal name is 'subsidiary' and semi-colons will be used as a separator.
- Set the "Type" to Free-Form Text.
- Uncheck "Store Value".
- Click the "Validation & Defaulting" subtab.
- Check the box for "Formula".
- In the text box for "Default Value" enter the following:
After saving the custom field you can see the results by viewing the NetSuite record. For this example named Multi-Select Subsidiary Field, you can see both of the selected subsidiary names appear separated by a semicolon.
Afterward go back to integrator.io, find the flow, and choose to edit the field mappings.
On the Mappings screen, create a new mapping where the newly created field is selected under the Export Field (NetSuite) column and the corresponding Salesforce text field that it should be mapped to.