Sync to salesforce multi select picklist field | Community
Skip to main content
Biren_Dhulia
Biren_Dhulia
Level 2
November 15, 2019
Question

Sync to salesforce multi select picklist field

  • November 15, 2019
  • 1 reply
  • 7149 views

I have a Multiple choice field in Marketo Form which is syncing to a Picklist (Not Multi Select Picklist) in Salesforce. So when leads go to the website and choose more than one option, only the first one syncs to Salesforce field. How do I capture all the options that lead had chosen? Do I just change the Picklist field in Salesforce to Multi Select Picklist?

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Mariah_Mattick
Mariah_Mattick
Level 3
November 18, 2019

Hi Biren! It may be best to align that picklist with SFDC's values to ensure proper data sync OR to align the SFDC field type to what users are seeing on the form (the multi-select). This will keep the data and user experience in 1-1 alignment between both systems. 

Mariah Mattick
Biren_Dhulia
Biren_DhuliaAuthor
Level 2
November 18, 2019

Hi @Mariah Mattick,

Thanks for your reply. Both the picklist values (Marketo & SFDC) are aligned. The reason all the values are not syncing is SDFC field is Picklist not Multi-Select Picklist & Marketo field is Multi-Select checkboxes on the form. If i just simply change the SFDC field to Multi-Select picklist, will that resolve the issue? Will Marketo recognize the field type change in SFDC?

SanfordWhiteman
SanfordWhiteman
Level 10
November 18, 2019

The situation actually has nothing to do with the type of form widget (Checkboxes).

It's solely about the value of the field: if you had a String or Textarea field on the form and filled in a semicolon-delimited string, or used a Change Data Value flow step, or the REST API, the outcome would be exactly the same.

The datatype in the Marketo database does not have a fixed relationship to the widget type. What matters is the value you try to fit in the field and whether SFDC understands it once it syncs over.

So yes, you must change the SFDC field to a multi-select picklist. Unlike in Marketo, the visual widget associated with an SFDC field is more closely related to the allowed value/s.

Terms & ConditionsAccessibility statement

Loading footer...