There shouldn’t be any special syntax involved for writing unicode characters—you can generate the unicode character however you would elsewhere, and then copy and paste it into Airtable. :thumbs_up: :100: :ok_hand:
I like your sample code using Emoji and think this is certainly a great way to start distinguishing records.
My two most common use of conditional formatting is to note when a calculated (usually a rollup counting linked records) does not match the expected quantity listed as a simple integer in the adjacent column. It’s how I keep track of the changing linked records.
I like how Airtable makes relational databases friendly. I’m just starting to use the power under the hood.
I think something that would work for me, which would still be Airtable-y, would be to have a “Highlight” button next to the “Filter” and “Sort”, where we can highlight rows that meet a certain requirement.
I normally use a blank row of a different colour to easily see where I am in a spreadsheet when there are several rows related to one idea. In the meantime a poor man’s work around I am using is to enter XXX in all the fields of the blank row that I would normally use a different colour in. So yes please to some additional formatting :slightly_smiling_face:
Seconded. I use this ALL the time in other spreadsheet programs, and it’s enough to drag me reluctantly away from my beloved Airtable. This would be a slam dunk.
Thanks for that suggestion of using the IF statement along with the IS_BEFORE to help highlight dates. It works for me, sort of…I have a table where not all of my entries have dates. While the workaround works nicely with all of the entries that have dates, any without a date report an error. Is there a way to deal with this?