Is it possible to set up a form and validate the email address entered against a predefined list of email addresses?

  • Profile Image
    Dan Colmer 
    Asked on June 04, 2020 at 06:43 AM

    Hi there -

    Is it possible to set up a form and validate the email address entered against a predefined list of email addresses?

    Is it also possible to export the data in an excel format?

    Thanks!

  • Profile Image
    ashwin_d
    Answered on June 04, 2020 at 09:37 AM

    I am not sure if I have understood your question correctly. Do you mean to say that you want to validate the email address of the user is matching with a list or not?

    If the predefined list is not a big list, you can add condition in form to achieve your requirement. If user's email address matches from the list, you can show a message to user in "Paragraph" field or perform different action. You may like to take a look at the following guide which should help you: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    If you have long list of email addresses, I would suggest you to please add "Spreadsheet to Form" widget in form. You can upload an excel file with email data in the widget. When user input email address in form, it will check in the excel file and fetch the data form uploaded excel file and populate your form fields which will help you validate. You may like to take a look at the following guide which should help you: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Hope this helps.

    Do get back to us if you have any questions.   

  • Profile Image
    ashwin_d
    Answered on June 04, 2020 at 09:42 AM

    I have moved your second question related to excel export to a new thread so that we can address it separately. You will be answered in the following thread: https://www.jotform.com/answers/2367903