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?
Is it possible to know what change triggered an automation in a script?
+3
+29The 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.
+3The 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.
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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.