Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 02, 2021 01:57 PM
I’d like to optimize my automation by running the same automation whether any field is updated, but perform a change related to the updated field only.
How can I know what field was updated from a script?
Mar 02, 2021 02:38 PM
The script cannot identify the updated field on its own. However, you could have formula fields do this. You could have last modified time fields for each of the inputs, and have the script compare the last modified times with the current time. Or you could have a formula field that uses last modified times to identify the field that was modified last.
Mar 02, 2021 02:44 PM
Thanks but that won’t be reliable, but the time the automation runs, other fields may have been changed and it might not use the field that actually triggered the automation.