Easy Way to check for a duplicate

Discussion created by alexissindicic on Jul 23, 2017
Latest reply on Aug 7, 2017 by donolee

Hello Filemaker (awesome) community,


i've read a lot of topic in this forum about finding duplicates values and i merely found a way to import unique data (using a processing table and a search function).


Right now i need to be able to find if a record (a website) is already in my database and flag it if it is the case.


My idea would be to have a function that does this :


  1. get the field i want to check for duplicate and put it into a variable
  2. open a new window and do a search of this term (though variable) in the database
  3. If result is >0 then i have a duplicate
  4. Otherwise it is a new record


Do you think it is smart ? is there an easier way for this check ?


Many Thanks for your help !