Hi all, I may be missing something in which case apols!
I have two fields: an integer field and checkbox field. I wish to set the checkbox field if the integer field is >x.
I can see how to simulate this using a formula field formatted as text and a ‘tick emoji’, but this doesn’t work for me as I need to link my base to an external system that uses airtable checkbox fields to construct filters.
Alternatively, would be nice to flag a feature request for the formatting option ‘Checkbox’ for formula fields where the output is boolean.
I’m using Stacker to create a customer portal, and it appears to construct filters based on field types in Airtable. You’re reply has clarified my thinking - so I think I should ask them - sorry to have troubled you!
It would be nice, however, to be able to format a formula field as a boolean checkbox if the formula simply delivers true or false - just helps with visibility and consistency with other checkbox fields - rather than creating an ‘if’ formula and then inserting a tick emoji and formatting it as text. Again, I may be missing something!
That definitely sounds like something that would benefit other Airtable users. You might consider posting to the Product Suggestions category (after searching to see if someone has already suggested this).