I have set up a masterlist of advocates that is pulling all of our advocates from different bases, using synced tables.
Now I want to have a field that will tell us when the person was last reached out to so we have a good overview.
I have set up an automation that says 'When this date field is not empty in this table, please update the date field in the masterlist table with the same data" However, it works only the first time. Afterwards, when the original date field is updated to a new date, it's not updating the field in the masterlist table.
Is there any way to make the automation triggers every time there is a new value in the original field?