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

Is it possible to get old values of a record in an "after update" automation?

Topic Labels: Automations
482 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have created an automation that runs a custom script after a record is updated. In the script I would like to perform different operations depending on the overwritten values. Is there any way to access those values from the script? (Similar to how one would use OLD in a SQL trigger).

1 Reply 1

Welcome to the Airtable community!

Scripting has no access to the previous value of a field. You have to design a system to hold the previous value in a different cell. This also typically means that users cannot directly edit the field directly in the grid view. Instead have a script or automation that copies the old value into a different field, and then puts the new value in the original field. Then the script reads the “old value” field to see what the old value is.