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.
Yup. On top of the traditional; In order to assure records are fulfilled properly. For example: When creating a new record and the Title field is filled, other fields in the same record can turn color to indicated a required field. Or could also be based on a priority field.
I would guess that this is one of our top five most requested features, and itโs definitely on our roadmap! Something else that we need to consider with regard to all of your feedback is whether โconditional formattingโ would mean row-by-row conditional formatting, or cell-by-cell conditional formatting, as these would essentially be completely different features in terms of implementation.
In the meantime, besides the suboptimal manual solution of tagging records with the color selections from a single/multiple select field, thereโs a cute little workaround you can do involving emoji/Unicode characters in formula fields. Letโs say that you want some way to easily tell whether something is overdue. You could use a formula: IF(IS_BEFORE({Due Date}, TODAY()), โ :boom: โ, " ") which would return the :boom: emoji if the value in the โDue Dateโ column is earlier than the current date.
Also, while we are trying to get people to abandon spreadsheetsโฆ sort ofโฆ :winking_face: , our philosophy is that we donโt want to just take features 1:1 from spreadsheets to Airtable: instead, we want to carefully reconsider the underlying use cases/problems to be solved and to find new design patterns that best solve these problems.
To this end, we would love any or all of you who expressed interest in conditional formatting to describe in greater detail how you might use this feature, so that we can take your particular use cases into consideration!
Katherine, while I do love your idea, I still see the need of formatting. I have been using solutions similar to what you suggest and they do work, better or worse depending on the case. To me the biggest reason to have conditional formatting is to reduce the amount of redundant fields. I am creating bases that extend forever to the left and using additional fields just to attract visibility to values in certain columns creates much wider workspaces. This compounds with the inability (maybe only mine?) to make columns really really really thin (like just fitting your emoji there). I know and often use views to restrict whatโs visible, but I do very often need a big overview of a lot of moving parts (and a bigger screen too, I know)
I would also love to apply conditional formatting in lookup fields to emulate single selects appearance. I often have lookup fields from single selects in another table and it would be ideal to keep or replicate the colors from the original table.
Katherine - @Patricia_Olender explains it perfectly. Iโm in the same situation. Although now that I think about it, I do need to keep those extra columns for people with trouble seeing colors. Nice idea with the emojis.