Background
Salesforce supports Picklist (Single Select) as well as Picklist (Multiple Select) https://help.salesforce.com/
Map Picklist (Multiple Select) fields in Salesforce to corresponding Multiple Select fields in NetSuite via integrator.io, you need to do the following in your field mappings:
-
Open your field mapping, then click Settings on the desired field in the NetSuite column.
- Under Field mapping type, select Multi-field.
-
Create a Multi-field Expression mapping as shown below.
-
In the Expression field, replace the semi-colon (“;“) with a comma (“,”).
Note: The last step is needed because the Salesforce API stores the value separated by “;” while NetSuite requires values separated by “,”. This handlebar expression manipulates the data so it conforms to the NetSuite-accepted format. If you are integrating Salesforce to another application, you may need to use a different expression.
For example:
{{replace FieldName ";" ","}}
Save to return to mapping settings:
Comments
This also works with hubspot, just an FYI.
What is the trick for syncing the other way (back to Salesforce)? I tried opposite Expression of {{replace field "," ";"}}, but no error and no update.
How about Netsuite to salesforce?
Please sign in to leave a comment.