This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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?