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
May 05, 2022 03:04 AM
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).
May 05, 2022 05:13 AM
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.