Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Currently have a multi select pick list in a Squarespace submission form. Not matter what combination I use for the formatter, and changing commas to colons and removing the spaces, the data will not plug into Salesforce. Is there a flaw with the system going to lightning?

 

Hi @ArmandVioli 

 

As per the SF API documentation, you should in fact separate the values using a semicolon. 

 

In the above screenshot, it does appear that a record was created in Salesforce with the value 31-80 Pads;81-150 Pads (which is the correct way to send the data to Salesforce). What does this record show in Salesforce? Just one select with the value as a string? 

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hey - Yeah so nothing comes up in salesforce. “Data In” like you said looks correct. “Data Out” shows that area as empty. I quadruple checked I have the spacing, capitalization and everything correct and matching but now matter what if I select one option, or multiple nothing will get input to salesforce. 

 

Hi @ArmandVioli 

Good question.

Make sure you are using the internal values expected by Salesforce for each option.

Sometimes the friendly display value is different from the internal option ID.

You can check this by looking at the list of multi-pick options, and take not of the value that is in the smaller gray font for each, as that is what Salesforce expects.

You may need to use a Formatter > Utilities > Lookup Table to translate values first.

 

Select more than one value from the dropdown field

If you have a multi-select pick list field in Salesforce then you can select multiple items by using semicolon character ; between them.

Alternatively if you're passing data from a previous step, you can use Formatter to create a string with ; as the separator.

@Troy Tessalone Hey yeah I triple checked both expected values and API inputs are exactly the same, literally have tried this 1000 different ways and cannot get it to input. Any other ideas?

 

Appreciate you and @MohSwellam help

 

@ArmandVioli 

Does it work with only 1 option?

 

Make sure there is no leading/trailing whitespace for the values.

 

@Troy Tessalone Yes tried that as well. No luck

@ArmandVioli 

Is there a setting on the Salesforce side that prevents those value from being set?

Hi @ArmandVioli 

I see that you’re already working with one of our Support Specialists. And here’s what they said,

So what I suspect is how Salesforce expected multipack lists to be shared with them. The next steps:

  • Try directly mapping (directly type into field) some picklist values separated by commas, semi-colons and test the SF step
  • Also try converting the the picklist values string above into line items and using the output instead into the SF field and retest the step

Just to confirm, have you tried these steps? If so, did any of them work?

If you’re having trouble with the steps, please continue working with our Support Specialist on this.

Thank you! 😊

Reply


Terms & Conditions