I am very, very new to Filemaker Pro and have a need that I am not sure how to handle. I am hoping FMP can help.
I downloaded a list of customers who had (at that time) opted in to marketing with my company on Friday 06/16/2017 (MarketingList_06.16.2017) and imported it into FMP.
I downloaded the list again on Monday, 06/19/2017 (MarketingList_06.19.2017) and imported it into FMP, instructing it to replace data based on a UniqueID, and add any new UniqueIDs as new rows of data.
But what if someone who was opted in to marketing on 06/16/2017 (and therefore on the original list) is no longer opted in and does not show up on the downloaded list from 06/19/2017? Does FMP have the functionality to remove or flag a person that is not showing up on a more recent list?
Basically, if a UniqueID is missing from the second list (06.19.2017) then I want FMP to either flag the UniqueID on the first list (06.16.2017) to alert me, or remove it automatically. Is this possible?
Thank you in advance for any assistance!