Forum Documentation Showcase Pricing Learn more

How To Check For Duplicates Of Things Based On Multiple/Any Matching Fields?


#1

I have a Thing that usually should have a unique name but sometimes duplicates are created.

The thing has:

  • Name
  • Phone number
  • Email
  • Address

Sometimes the name will be similar, such as, “Thing Name Apple” and “Thing Name Pear”.

What I’m trying to do is search for all things with names containing “Thing Name” (using example above) AND THAT ALSO CONTAIN matching or duplicate entries for any of the following to be able to determine if the name is similar but the rest of the information is unique, or that the two entries are indeed the same, and should be merged together:

  • Name
  • Phone number
  • Email
  • Address