Updating airtable checkbox field

I’m trying to update an airtable checkbox field using data from a Google spreadsheet. The spreadsheet is giving me “TRUE” or “FALSE” and I need to convert this to the right yes/no value for the airtable update.

I tried this (and variations on it):

In this case it always updates the checkbox to checked. In some of my attempts it always set it to unchecked. I don’t get an error, I just don’t get the right result. I also tried it with just the contains function without the if statement wrapping it.

Thanks for any suggestions!

1 Like

Hi @DanaBergen

Thanks for reaching out to the community. Instead of using the contains() function, use {{=}} operator to compare the value.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

The issue here is you have inserted double quotes around the “TRUE”.

Remove the double quotes like this:

TRUE 

you should also probably remove the extra spaces before the yes/no as well.

Hope this helps! Let me know if there are any further questions or issues.

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

1 Like

Neither of these suggestions worked. But I did find a solution. I changed the condition to K != FALSE, and for some reason this worked even though K = TRUE did not, and I know for sure the values being passed were TRUE and FALSE. It now evaluates correctly for either case. I have no idea why this fixed it.

3 Likes