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.

Hi there

I have seen a version of this question here and tried the Utilities Formatter with limited success. My squarespace form has several fields and one field that is a “select” field with three options. I am trying to map it to a custom opportunity field in Salesforce with the same with three picklist options. I have created a lookup key and a lookup table with 3 options. When the Zap tests itself it creates an option one opportunity in Salesforce. When I test it in real time with the actual squarespace form and choose option two it it creates an opportunity with the fallback value instead of option two.

That seems to indicate anything besides option one isn’t recognized.

 

Ideas?

 

thanks for your help~

 

Hi @pg0112 

Good question.

To troubleshoot, check your Zap Runs history details to see the DATA IN/OUT for each Zap step to help you understand the data values were used.

https://zapier.com/app/history/

thanks!

 

data in:

transform:    util.lookup
inputs:    donated via a drop-off location
table:
Option One:    shipped directly to FTG
Option Two:    shipped via Give Back Box
Option Three:    donated via a drop-off location
fallback:    None
values:
1:
inputs:    donated via a drop-off location

 

data out:

output:

None

Does this give you any insight?

@pg0112 

Better to provide screenshots, thanks.

 

@pg0112 

Make sure there aren’t extra spaces before/after or in the middle of either the input value or the lookup option.

I appreciate you persevering with me~

I had thought of spaces and spelling myself. I did check that- and I just re-did and re-checked.

Mystifying to me- the internal zap check works for option one. But the realtime Squarespace form check returns the none value for any of the options.

 

Let me know if there are othr helpful screenshots I shoud share

 

 

@pg0112 

Might be due to the data point type: string VS array

Try using a Formatter > Utilities > Line Items to Text step first.

Your answer didn’t work- but I followed this advice below and renamed my options. instead of option two and three I used the actual answer in both columns of the lookup table- and that did it :)

 

 

@pg0112 Wonderful! So glad you were able to find a solution to this through another thread. 🙂

Terms & Conditions