I’m comparing two currency values in a table, and attempting to flag if there is a mismatch. The way I’d do this in gSheets is pretty obvious:
=IF(field1 = field2, TRUE, FALSE) - then conditionally format on TRUE or FALSE to get a visual indicator. I actually like that there is no range-based conditional formatting in airtable, since these are meant to be DBs - but I still think a coherent display of true/false values (As a checkbox!) is reasonable and I shockingly don’t see a way to do that here.
Yes, I could do something idiotic like represent it with an emoji, but that’s a nasty hack if I want to query for items in my table whose cost-match is FALSE.
Yep, your choices currently are
'❌'— which, as you note, makes direct querying of the field a pain. (Typically, I create a formula field that equates to
0and hide it, with another formula field that translates
'❌'; I filter on the first field.)
1,0onto an adjacent checkbox field. Obviously, this must be updated after every change to the base that adds a record or results in the recalculating of your formula field.
Are any of these workarounds you’re likely to accept without much grumbling? Probably not…
I’m not sure what you mean by this, though, as you could set the record highlight color to indicate whether the field is true or false (
0). You can’t color the field, per se, just the containing record.
Of course, with a Pro plan, infinite patience, and little social life, there’s no end to what one might accomplish with the Page Designer Block. :winking_face: