Hi, I’m using Airtable for ecommerce product management.
I have a “calculation basis” and a “calculation” table, which makes calculations based on the “calculation basis” table (self-explaining).
In the calculation basis (using the gallery view), I would like to clearly show which fields need to be filled manually for the calculation table to later do its job without problems (missing fields due to missing references).
So, I would like to visually show necessary fields in the gallery view (other view might be fine as well, but the others aren’t really suitable except for Grid where you have to scroll to the right a ton).
Conditional coloring would just mark the entire record without one knowing what exactly is missing.
Any ideas how to do this?