Best answer

Advice for converting text to Boolean

  • 13 January 2021
  • 6 replies

Userlevel 1

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 14 January 2021, 04:42

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.

6 replies

Userlevel 7
Badge +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.

Userlevel 1

Hey @Troy Tessalone !


If the user selected the first two checkboxes the return is:


“Programs for young people, Performance opportunities,”


Does that help?



Userlevel 7
Badge +14

What if the users select the first and third options only?

Userlevel 1

“Programs for young people, Music Business,”

Userlevel 7
Badge +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.

Userlevel 1

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!