Hello Filemaker Community,
I have three tables
has : website_url_clean field
I have managed to create an import script (thanks to this amazing community) that will import contacts in the contact table.
I am looking for a function that will allow me to test, in my importing loop, if i already have a record with the same website_url_clean field.
If the result is No -> I can move on and create the correct record
If the result is Yes -> I can link the already existing contact to the Campaign i'm working on
Basically i just need to understand how to test if a record in the database is already matching the record i'm trying to import.
Many thanks for your ideas