This may be a pretty simple problem, but I’m brand new to Airtable and haven’t been able to figure it out.
I would like to mark a row as “complete” when all the fields in that row are filled. (in a perfect world I’d love the entire row to change color… but at this point I would just settle for a field marked “done”)
Say I have a list of products… and I want to collect 5 leads of possible retailers who could sell each item. Once i’ve found 5 retailers for that product I want that row marked as “complete” (turn green or something.) The problem is that some of the rows will contain urls, some contain emails, some contain nothing more than a short text phrase.
I basically just want to know when all the fields contain SOMETHING… In excel it would basically be (if cells 2-6 are NOTBLANK color = green)
Can i do this on Airtable?