Sync two tables to a third table
I have two tables with the exact same fields. How do I sync these two tables to a third table with the same fields automatically? If a record is added, modified or deleted in the first two tables, the...
Forum Discussion
I was able to do this using Automations.
------------------------------
Gopi Mandela
------------------------------
------------------------------
Gopi Mandela
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend... out of curiosity, how many Automations did it take?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- I used three, maybe there is a more efficient way to do it.
Automation 1: When a record is added in the source table, I created a unique "Sync Key" in that table and added the record to the target table along with the Sync Key.
Automation 2: When a record is modified in the source table, I modified the record with the matching Sync Key in the target table.
Automation 3: When a record is deleted in the source table, I deleted the record with the matching Sync Key in the target table.
------------------------------
Gopi Mandela
------------------------------