A multi-select field can be mapped in a SugarCRM Acoustic Campaign integration through the Scribe Online with an Acoustic Campaign multiple selection.
In the following scenario, consider an example where a field named Hobbies exists in both SugarCRM (MultiSelect) and acoustic Campaign (Selection (Multiple)). In the sample data below, the list of selected data is stored differently in each platform which requires it to be transformed for insert or update into the opposite system.
When querying a SugarCRM MultiSelect field using the Scribe Online SugarCRM connector, the result will be a comma followed by a space-separated string. For example:
Note: These represent the "Item Name" not the "Display Label" as defined for the MultiSelect list within SugarCRM.
[ "Snowmobiling", "Boating", "Water Skiing" ]
For more information, see Scribe's SugarCRM connector Help file.
When querying an Acoustic Campaign "Selection (Multiple)" using the Scribe Online "Silverpop" connector, the result will be a semi-colon delimited string.
The following Scribe online mapping formula examples may help transform Source data format into the necessary format for insert or update into the Target system. You are responsible for testing the formulas to ensure that the data is indeed transforming and syncing as needed.
Note: It is highly recommended that you focus on mapping the data from one direction to the other first before mapping the data back so you know you got it right before syncing large numbers of records.
- If you set the Acoustic Campaign Hobbies field as the Target, the formula is:
REPLACE(Leads.hobbies_c,", ",";" ).
- If you set the Acoustic Campaign Hobbies as the "Source", the formula is:
REPLACE( WCADatabase_Lead.Hobbies,";",", " ).