Stop Duplications

[Joe_Hersom]

I can’t seem to get my scenario to stop duplications. Can anyone see what I’ve done wrong?

This is how it is supposed to work:

1. A webhook receives the name and email.

2. A Data Store checks whether the email already exists.

3. The scenario goes through a router:

   • If the email exists, it should go down the “duplicate” path (which does nothing).

   • If the email does NOT exist, it should:

     • Add a row to Excel

     • Check the response field (YES/NO)

     • Send the appropriate email

4. The email is then added to the Data Store, so if the link is clicked again, it checks the Data Store and prevents duplication.

I have managed to partially get this working, but it still doesn’t stop duplicates. The duplicate filter isn’t catching the existing email, and new submissions are being added again.

Can anyone see what I’ve done incorrectly or what I should change?

[Ra_ul]

Maybe post the logic from your filter, and also the output from the database in module 3?

However, there is a specific datastore module to check the existence of a record named exactly so

It might be helpful.

I am still a newbie in make so let’s see if someone else has a better idea

[RicardoL]

Most likely, the filter in the router, or maybe the one right before it (the Data Store’s Search Records), isn’t set up right to check if the email was actually found.

[mszymkowiak]

Hello,

1. Does your database use email as a key? If not, you should use the “search” module instead as key by default is random-generated by Make.com (user must change that while creating record)
2. Please share a screenshot of your filter configuration - if the bundle passes the filter, there is a misconfiguration that allows it.
3. One possible configuration is to use length() function (map it with your data store email key) and a greater-than filter. Meanwhile you can try it out.
   
   

[Joe_Hersom]

This worked! Problem Solved!