Map picklist (multi-select) fields in Salesforce

Docs Support
  • Updated

Background

Salesforce supports Picklist (Single Select) as well as Picklist (Multiple Select)  https://help.salesforce.com/ articleView?id=fields_ creating_picklists.htm&type=0

picklists.png

 

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:

  1. Open your field mapping, then click Settings on the desired field in the NetSuite column.

  2. Under Field mapping type, select Multi-field.

  3. Create a Multi-field Expression mapping as shown below.

  4. 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 ";" ","}}

 

settings.png

Save to return to mapping settings: 

mapping.png

Related articles

Comments

2 comments

Date Votes
  • Jesse Guzman
    Engaged
    Celigo University Level 4: Legendary

    This also works with hubspot, just an FYI.

    0
  • Damon Betlow

    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.

    0

Please sign in to leave a comment.