Hello All!
I’m looking for some advice and tips to approach the following Zap I’m trying to create, any hints or pointers greatly appreciated!
I have a form on our Squarespace site which has check box inputs with outputs comma separated response.
For each of this check boxes on the form I have a matching checkbox in Salesforce which I want to select.
What approaches could you suggest to solve this?
Best answer by Troy Tessalone
View original
+14
Can you show examples of how the data is returned from Squarespace?
Trying to determine what the data output is if only a subset of checkboxes are ticked as that will impact the proposed solution.
Hey
If the user selected the first two checkboxes the return is:
“Programs for young people, Performance opportunities,”
Does that help?
+14
What if the users select the first and third options only?
+14
You can use the Formatter Text Split (by comma) OR Utilities Line Items to get the individual selected options.
There could be from 1-6 options checked.
But the trickier part is to then check and maps the selected options.
You could try creating a looping Zap with a GSheet and line items.
Or you may have to take a more technical approach and use a Code step.
Hey Troy Great Video!
It triggered an idea which is to go from website to g-sheet, sort out the formatting/transform of the data there and go from there!
So thanks for your inspiration!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
