I am trying to set a Multi-Select List with Salesforce.com as my destination, how do I do this with SmartConnect.
Salesforce.com uses semi-colons to separate the values within a multi-select list. To be able to set multiple values, use a calculated field that concatenates strings together to have multiple values set on the multi-select list.
This is an example where we can set a list of languages the contact is able to communicate. Using the boolean values from the source, I set the required List strings together.
Dim MySelectListString as string
MySelectListString = string.empty
if _SPANISH then
MySelectListString = MySelectListString & “Spanish;”
end if
if _ENGLISH then
MySelectListString = MySelectListString & “English;”
end if
if _GERMAN then
MySelectListString = MySelectListString & “German;”
end if
if _ITALIAN then
MySelectListString = MySelectListString & “Italian;”
end if
if _FRENCH then
MySelectListString = MySelectListString & “French;”
end if
‘Remove the trailing semicolon
if MySelectListString.Length > 0 then
return MySelectListString.Substring(0, MySelectListString.Length-1)
else
return String.Empty
end if
