Using Airtable filterByFormula with a checkbox field

[bmceuen]

hey all, my app is connected to airtable via external collections. so I use filterByFormula quite a bit.

One of my fields in airtable is a checkbox (boolean) field, and I’m trying to filter by that field, something like {fieldName} = false

but that doesn’t seem to work. It also doesn’t seem to give me any airtable 400 errors.

I have a custom action that is able to update that field with no problem.

any thoughts on this one?

[pford]

I believe this might be case sensitive and it’s thinking that you’re asking if the field contains the string “true”. Can you change it to TRUE() instead and see if that fixes it?

[bmceuen]

thank you, i believe this worked!