Help

Auto update a field when record is added

5962 13
cancel
Showing results for 
Search instead for 
Did you mean: 
KVC
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table of people who could potentially be used as presenters. When a new record is added to the table (usually via a form), I want the field “Status” to update to “Potential”. As a completely separate step, when an event is connected to that person’s record I want the Status to update to “Active”. Any advice? I’ve used zapier for a few things in Airtable, but haven’t been able to figure this out. Thanks in advance.

13 Replies 13

If you have a pro account, you could color code the record based on the formula value.

KVC
5 - Automation Enthusiast
5 - Automation Enthusiast

I do have a pro account. Could you provide an example? Thanks!

coloring.JPG

In the example above, I have a table that is color coded based on a calculated field’s value.

KVC
5 - Automation Enthusiast
5 - Automation Enthusiast

Oh, yes, I know how to do that. I was hoping to get the words in the field to be color coded like they in a single select. Thanks for showing me this!