Jun 05, 2024 10:02 AM
Many thanks for considering my request.
I have a Table A. I chose the "When a record is updated" option in the Automation trigger with multiple field selections, and the Next step is Scriptwriting, In the script, I need to track which field has been updated recently (i.e. which updated field triggers this automation).
Eg: Table A
Field 1 | Field 2 | Field 3 | Field 4
These four fields are selected in the "When a record is updated" option of the Automation trigger.
If Field 1 has been updated recently, we need to track that Field 1 has been updated recently.
If Field 2 is updated recently, we need to track that Field 2 is updated recently.
Based on the Field update I have to write logic.
Solved! Go to Solution.
Jun 05, 2024 10:50 AM - edited Jun 05, 2024 10:50 AM
I'm not sure if its possible to detect which field has been updated. But a workaround for your problem would be to have multiple Automations.
For example:
- if Field 1 has been updated -> Trigger Automation1 for Field 1.
- if Field 2 has been updated -> Trigger Automation2 for Field 2.
In every Automation you will have the trigger for only one Field. Base on the Automation you know which field was updated.
Jun 05, 2024 10:50 AM - edited Jun 05, 2024 10:50 AM
I'm not sure if its possible to detect which field has been updated. But a workaround for your problem would be to have multiple Automations.
For example:
- if Field 1 has been updated -> Trigger Automation1 for Field 1.
- if Field 2 has been updated -> Trigger Automation2 for Field 2.
In every Automation you will have the trigger for only one Field. Base on the Automation you know which field was updated.
Jun 06, 2024 07:00 AM
Thank you. It works since I have 12 columns only.