Best answer

Advice for converting text to Boolean

  • 13 January 2021
  • 6 replies
  • 429 views

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?

 

 

 

icon

Best answer by Troy Tessalone 14 January 2021, 04:42

View original

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! 

 

 

Reply