how to verify if the email is in our database?

  • DeGroupe
    Asked on September 6, 2024 at 9:39 AM

    when the user submit the form with his email, i wouldlike to know if it's possible to check if the email is in our database.

    And then, after check, if yes forward to a positive thanks page.
    if not, forward the user to negative page : the email doesn't exist.

    thank you

  • Christopher JotForm Support
    Replied on September 6, 2024 at 10:05 AM

    Hi Alyah,

    Thanks for reaching out to Jotform Support. It is not possible to check if the email address already exists on the Tables and then send the user to a negative page, but we can use the Unique Field feature that prevents duplicate submission. Here's how to do it:

    1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

    2. Click on Show More Options.

    3. Scroll down to Unique Field.

    4. Select Email form element.

    how to verify if the email is in our database? Image 1 Screenshot 20

    We also have a guide about How to Set Form Limits Based on a Unique Field that you can check out.

    Give it a try and let us know how it goes.

Your Answer