Convert Yes/No Text to Boolean Values

  • 18 March 2022
  • 2 replies

Hi all,

I am trying to integrate Facebook Lead Ads with Workable. I have a field on facebook lead ads that returns the answer Yes or No. However, Workable needs the answer in boolean format as true or false. How can I convert the values to boolean?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 1

Use a lookup table step, in formatter → utilities.

Use the field from Facebook lead ads as the lookup value.

For ‘Yes’ - ‘true’

For ‘No’ - ‘false’

Then use the output of this lookup step in your Workable step.

Userlevel 7
Badge +14

Hi @imercann 

Good question.

Here’s a help link about the Formatter > Utilities > Lookup Table: