Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
5 years ago

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 fi...
Quickbase Automations
JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
5 years ago
I have a record with 1234 in table A and when I change it to 1235 it copies across to table B. 
It is doing this correctly with all the values.  Problem is, if I change the same record in table A to difference value i.e. 1236, save then change it to 1235 again, it copies a new record across to table B.

------------------------------
Jessica Matenga
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
OK, how about adding a step to your Automation which updates the record in table A so it knows that it has already been copied.  Then adjust the trigger not to copy records which have already been copied.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------