Help

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

966 0
cancel
Showing results for 
Search instead for 
Did you mean: 
holidoit_s_r_l
4 - Data Explorer
4 - Data Explorer

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.