FM - Tracking Changes from an Update Import
Posted on 2014-04-08
Thought I could easily track new records added via a Filemaker Import ("Update matching records in found set" and "add new records"). However, our tenants can not only add a record via our website, but they can delete one too. Thus, my script method of compariing the old vs. the new found record set will not work.
Am I going to have to export from the current to a a backup database first in the script and then compare records? Any in the old and not in the current have been deleted and any in the current and not in the old are new records. Is that the way you all would do it?