Copy records from one table to another - Auotmations
Hi
I have managed to create an automation to copy records from one table to another table when a field is changed to a specific value. The trigger is when a user modifies or adds a record and the field is changed. I am testing the automation and yes, each time I change the field it copies a new record to the other table.
Can someone please help me - if the record that already has the value is modified, how can I get it to change the existing. Currently it is copying the record each time I change the field.
Thank you in advance.
------------------------------
Jessica Matenga
------------------------------
I have managed to create an automation to copy records from one table to another table when a field is changed to a specific value. The trigger is when a user modifies or adds a record and the field is changed. I am testing the automation and yes, each time I change the field it copies a new record to the other table.
Can someone please help me - if the record that already has the value is modified, how can I get it to change the existing. Currently it is copying the record each time I change the field.
Thank you in advance.
------------------------------
Jessica Matenga
------------------------------
