Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

Tracking Changes with Connected Tables

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
------------------------------
Quickbase Automations
Quickbase Sync
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • NirajShah4's avatar
      NirajShah4
      Qrew Cadet
      5 years ago
      Thanks, Mark. This is the method I utilized.

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