Airtable checkbox unchecked absent in bundle

Hi Makers!
My scenario is triggered by a webhook followed by an Airtable “Get a record” module.
In the airtable database, I have a checkbox field.
When the checkbox is checked, I can see in the Airtable module output the item with the value as “true”.
But when the checkbox is unchecked, I cannot see in the Airtable module output the item. The item doesn’t show up at all!
Any idea to get the item with the value as “false” when the Airtable checkbox is unchecked?

Thanks for helping.

@Vianney :raised_hands:

Hi there! Thanks for reaching out to us. It sounds like you’re having trouble with the Airtable module output when the checkbox is unchecked. Could you please provide a bit more detail about the issue you’re experiencing? That way, our community members can better assist you. We look forward to hearing from you soon!

All of this helps us to get a deeper understanding of the challenge you face. :make:

That is the default behavior of the checkbox in airtable. You may have to create another column so the API can output the desired result.
When you create the new column as a formula, use below formula replace checkbox with your actual checkbox column name.
IF(Checkbox = 1, “true”, “false”)
This should show the result of the formula column in the get record or search modules on your next run.

2 Likes

I am surprised that the item does not appear in the output when the checkbox is not checked. Thanks for clarifying that this is the “normal” behavior of Airtable. So I created a new field with the formula and it works fine. Thanks

1 Like