Tracking Changes with Connected Tables

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community