Help

Best Way to Capture and Record Field Value Changes

4699 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Ish_Rojas
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!