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) andAcoustic 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.
[ "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.
- 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,";",", " ).