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.
‎Aug 16, 2024 12:09 PM
Hoping someone can help, I saw in Airtable's 'What's New' update in July that if a formula returns "a boolean (true/false), a new formatting option lets you output the result as a checkbox instead of a number".
This would be really useful for me, but I have tried multiple ways to do this and have not sound it possible. I know Airtable's checkboxes mostly use 1 for checked and 0 for unchecked, so have tried outputting formula as a 1 or 0 for true / false, but no luck (tried "1" / "0", "true" / "false" etc too). Here's the screenshots from the 'What's New' page, if anyone has had any luck with this, help would be really appreciated.
Thanks
Matti
Solved! Go to Solution.
‎Aug 16, 2024 03:15 PM - edited ‎Aug 16, 2024 03:25 PM
Yeah, it’s odd that Airtable doesn’t explain this anywhere. Your output either needs to be TRUE() or FALSE()
— ScottWorld, Expert Airtable Consultant
‎Aug 16, 2024 03:15 PM - edited ‎Aug 16, 2024 03:25 PM
Yeah, it’s odd that Airtable doesn’t explain this anywhere. Your output either needs to be TRUE() or FALSE()
— ScottWorld, Expert Airtable Consultant
‎Aug 16, 2024 03:19 PM
Thank you Scott!
‎Sep 01, 2024 10:22 AM
Ignore the AI robot spam response by @Dgmeinsider. It is incorrect info, and the issue was already solved above by me.