Skip to main content

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 ?

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.


Reply