Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date a field status is changed

Topic Labels: Formulas
447 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am looking to create a formula that enters a date when the status of another field is changed

scenerio:

a field called “Job State” is changed to “sent to writer” and then the formula would fill in the date that action was made

I am then going to build a Zapier Zap to kick out a status update email to the client

1 Reply 1

You can use the “Last modified time” field type to capture the time a field is changed. However, if you change the “Job State” field again, then this field will change again. There’s no way to set it up to hold the date of a change to just a particular status option:

CleanShot 2020-03-25 at 14.38.44

But you could potentially combine this with a Script block that works on a view filtered to show only records where “Job State” == “sent to writer” – the Script block could grab the value of the “Last modified time” field (which would be the time that the “Job State” field was changed to be “sent to writer”, ergo the View filter), and write it to a Date field called “Date Sent to Writer”.