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 @Troy Tessalone !
If the user selected the first two checkboxes the return is:
“Programs for young people, Performance opportunities,”
Does that help?
What if the users select the first and third options only?
“Programs for young people, Music Business,”
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!