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