Skip to main content

Checkbox returns 1 or null, why not 0?

  • May 11, 2021
  • 1 reply
  • 25 views
M
Forum|alt.badge.img+2

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 ?

    This topic has been closed for replies.

    1 reply

    Adam_Minich
    Forum|alt.badge.img+18
    • Adam_MinichEmployee
    • Employee
    • May 12, 2021

    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.

    Terms & ConditionsAccessibility statement