Forum Discussion

GopiMandela1's avatar
GopiMandela1
Qrew Member
6 years ago

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 changes should reflect in the third table. 

Thank you.

------------------------------
Gopi Mandela
------------------------------
Quickbase Automations
  • GopiMandela1's avatar
    GopiMandela1
    Qrew Member
    6 years ago
    I was able to do this using Automations.

    ------------------------------
    Gopi Mandela
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      ... 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
      ------------------------------
      • GopiMandela1's avatar
        GopiMandela1
        Qrew Member
        6 years ago
        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
        ------------------------------