In QB sync with keep all records, is there a way to identify records that have been deleted from the source csv table so that they can be marked as inactive in QB?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I am using QB sync with a csv table stored in Dropbox.  I am using the option to keep all records and add new, so that all records are preserved.  However I would like to identify all records that have been deleted from the source csv table and mark them as inactive in QB.  Newly added records and modified records can be identified based on the Date Modified and Date Created fields.  However I have not found a way to identify records that were deleted from the source table versus records that are still in the source table but just not updated.

Photo of Michael

Michael

  • 30 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
It is perhaps a brute force solution, but you could double Sync to another table where you keep only the current records.  Then make a relationship between the two tables and flag which ones of the "children" in the "Keep All" Table have no Parents in the "Active Only" table.