How can I limit the access to my form by email addresses?

  • KasparsLubins
    Asked on February 19, 2019 at 2:30 PM

    I want the form to be accessible and filled only by the owners of certain email addresses. 
    I have added the e-mail validator add-on, but it doesn't seem to restrict the form to any email addresses, only asks the email address to be confirmed, so its not what I need. Is there a solution?

    Regards,
    Kaspars

  • Victoria_K
    Replied on February 19, 2019 at 3:54 PM

    Hello Kaspars - Firstly, you can disallow free addresses if this is what you would like to do:

    How can I limit the access to my form by email addresses? Image 1 Screenshot 30

    If you would like to allow only addresses with certain domain, I would suggest to apply some conditional logic. You could show a custom warning created using text element and hide Submit button, for example. 

    Related guide: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    How can I limit the access to my form by email addresses? Image 2 Screenshot 41

    Let us know if you need more help. 

  • KasparsLubins
    Replied on February 19, 2019 at 4:43 PM
    Hello,
    I eant only may emplyees to be able to fill out the form, nobody else. Those can be free domain email addresses, but they should be in my “list”.
    Is there a way for the condition by the field compare the value of the e-mail address field to my list?
    Kaspars
    ...
  • KasparsLubins
    Replied on February 19, 2019 at 4:43 PM
    So once more, from the beginning:
    I have a form that I want to be accessible only for a certain email
    addresses - my employees. I have a list of those addresses.
    I have intended to send the form to their emails and allow them to fill
    the form.
    I want to be sure that if any  other person who is not on my "list" gets
    the link to the form - it is useless to him, because he cannot access it.
    So I think that there should be some kind of email address verification
    function, that verifies, that the email address is on my list and that
    the user who is currently entering the email address is in fact the
    holder of the particular email address, not just someone who know the
    email address of my employee.
    I hope I have explained everything in enough detail. Please see a
    screenshot of the first page of the form, where i wanted to verify the
    email address.
    The "Submit" button is on the very bottom on the last page of the form,
    which sends in the data.
    I dont want the foreign people/outsiders to even see the next page of
    the form, if they are not on my list and cannot verify they are the
    owners of the email address.
    ...
  • Welvin Support Team Lead
    Replied on February 19, 2019 at 7:06 PM

    How many employees do you have? I have two solutions in mind. The first one is by using our spreadsheet to form widget (for long list of employees, maybe 20 or more) and the other is my colleague's suggestion through conditional logic (fewer employee).

    Here's a demo for the 2nd method: https://form.jotform.com/90497645873978. Enter any of the below demo email:

    email1@email.com

    email2@email.com

    email3@email.com

    It's by show/hide conditional logic. I've set the condition to show the page break only when an email is on the list.

    The full condition:

    15506211132019 02 20 008 Screenshot 10

  • KasparsLubins
    Replied on February 20, 2019 at 3:43 PM
    Hello, could You please show me the first ideas turorial using the spreadsheet to form widget (for long list of employees, maybe 20 or more)? The second one is not going to work, i have around 80 addresses. A google spreadsheet to which the email field would be compared to would be a great method, I just dont know hot to make the form to access the spreadsheet and look through the list in it.
    Kaspars
    ...
  • Victoria_K
    Replied on February 20, 2019 at 4:55 PM

    Of course. Spreadsheet to Form widget is designed to populate form fields based on unique code entered. But, since it can validate an input by sheet lookup, it can be used in your case with option to submit input value enabled. Please create an excel sheet, which has email addresses in one column and attach it to the widget. Here is our full guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    And a screenshot:

    How can I limit the access to my form by email addresses? Image 1 Screenshot 20

    If you face difficulties while setting this up, please get back to us and we will gladly assist.