Skip to main content
Answer

Advice for converting text to Boolean

  • January 13, 2021
  • 6 replies
  • 649 views

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

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.

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 13, 2021

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.


  • Author
  • Beginner
  • January 13, 2021

Hey @Troy Tessalone !

 

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

 

“Programs for young people, Performance opportunities,”

 

Does that help?

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 13, 2021

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


  • Author
  • Beginner
  • January 14, 2021

“Programs for young people, Music Business,”


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • January 14, 2021

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.


  • Author
  • Beginner
  • January 15, 2021

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!