AnsweredAssumed Answered

Check if record exist + IF function

Question asked by alexissindicic on Jun 22, 2017
Latest reply on Jun 22, 2017 by erolst

Hello Filemaker Community,


I have three tables

a) Campaign

b) Contact

   has : website_url_clean field

c) Join_campaign_Contact


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