Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Best Way to Capture and Record Field Value Changes

2966 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table with a column titled Status. It contains four statuses New, Answered, Rollover, Completed.

I want to capture the result when a Status changes, for example, from New to Answered, from New to Rollover, etc. I also want to report it compactly.

Further, I want to capture and count the Status changes in a Pivot Table or similar. I have looked at nested IF/SWITCH as well as Automation timestamp.

But being new to Airtable I am unsure which is simplest and most efficient. The Automation solution seems like many columns and not suited to a Pivot Table.

Any help appreciated.

10 Replies 10

Oops! Figured this out. Posted too soon. Nevermind!