Best answer

Squarespace form Select list to Salesforce opportunity picklist

  • 27 October 2022
  • 9 replies
  • 91 views

Badge

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~

 

icon

Best answer by pg0112 28 October 2022, 03:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Userlevel 7
Badge +14

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/

Badge

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?

Userlevel 7
Badge +14

@pg0112 

Better to provide screenshots, thanks.

Badge

 

Userlevel 7
Badge +14

@pg0112 

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

Badge

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

 

 

Userlevel 7
Badge +14

@pg0112 

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

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

Badge

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 :)

 

 

Userlevel 7
Badge +9

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