AnsweredAssumed Answered

Importing / Replacing Data Question

Question asked by sengeling on Jun 20, 2017
Latest reply on Jun 20, 2017 by sengeling

Hello!

 

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!

Outcomes