Discussions

Expand all | Collapse all

Tracking Changes with Connected Tables

  • 1.  Tracking Changes with Connected Tables

    Posted 04-28-2020 13:26
    I have two tables in two separate QuickBase applications, App A and App B. 

    I have a report in table in App A that I need to emulate in App B with the correct number of records from one to the other. However, I also need to be able to identify in App B when a record is removed from the report in App A. Basically, if there were 212 records in App A yesterday there will be 212 records in App B yesterday as well. Today, there are 210 records in both Apps; but I need to be able to somehow identify the 2 records that were removed in a new report in App B.

    What would be the best native QuickBase way to achieve this solution?

    ------------------------------
    Niraj Shah
    ------------------------------


  • 2.  RE: Tracking Changes with Connected Tables

    Posted 04-28-2020 13:45
    I suggest using an Automation to trigger when a record is deleted to update records in the other table with a checkbox or maybe a date that the record was deleted.  I assume that the Sync table has the Record ID# of the source table, so the Automation will know which record to update.

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



  • 3.  RE: Tracking Changes with Connected Tables

    Posted 04-28-2020 20:22
    Thanks, Mark. This is the method I utilized.

    ------------------------------
    Niraj Shah
    ------------------------------