Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Checkbox returns 1 or null, why not 0?

1485 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthieu_Rouvin
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,
As I understand (but I might wrong), a checkbox returns 1 or null.
Shouldn’t it be returning 1 or 0 (“True” / “False” or “checked” / “unchecked”) to be more useful ?
It would then be usable in pivot-tables or other kind of summaries.
Thanks for your help ?

1 Reply 1
Adam_Minich
Airtable Employee
Airtable Employee

Hi @Matthieu_Rouvin,

Adam from Airtable here.

The behavior probably looks like a null result in the UI, but, on the backend, the checkbox field is in the true/false, 1/0 (boolean) format.

Short video explanation here: Screen Recording 2021-05-12...

Cheers, and let me know if you are running into something else.