Discussions

Expand all | Collapse all

Sync two tables to a third table

  • 1.  Sync two tables to a third table

    Posted 19 days ago
    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
    ------------------------------


  • 2.  RE: Sync two tables to a third table

    Posted 18 days ago
    I was able to do this using Automations.

    ------------------------------
    Gopi Mandela
    ------------------------------



  • 3.  RE: Sync two tables to a third table

    Posted 18 days 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
    ------------------------------



  • 4.  RE: Sync two tables to a third table

    Posted 18 days 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
    ------------------------------