What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Lookup List for eMail addresses before Download

    Asked by XLAutomation on November 24, 2014 at 11:28 PM

    Hi,

    We have used Jotform for some basic capture forms on our website and it is a great tool...

    I would like to be able to do the following with a form from our website

    We have a list of email addresses.....our website subscribers. This list is contained in a spreadsheet

    We want to provide a free download to those subscribers after they validate against their email address. So they will enter their email address on the form and then it will lookup to the list of valid email addresses.

    If the email address is found an email will be sent to that email address with the free download

    If it is not found then a message will be displayed indicating they don't have access to that download...

    Is this possible with Jotform ?

    If so can someone point me to an example that we can use to create this for our site...

    Regards

    Scott

    email JotForm message create site
  • Profile Image
    JotForm Support

    Answered by EltonCris on November 25, 2014 at 03:02 AM

    Hi Scott,

    I am thinking of the following workaround which I think might help.

    Using email condition, you can fire up different notifications if the condition is met.

    Example: We'll be using If Contains condition as it allows list of data separated by comma. e.g. email1@yahoo.com, email2@gmail.com

    If Email Contains "email1@yahoo.com, email2@gmail.com"

    Send "Download Notification" to the user's {email}

    Here's a step by step guide:

    1. First, create two different notifications. 1 with the download link for the verified users and the other one for the user's not on the list.

    Example:

    2. Create an Email Condition, just like I've stated above. See the following screenshots.

    If you need further assistance, let us know.

    Have a good one!

  • Profile Image

    Answered by XLAutomation on November 25, 2014 at 04:56 AM

    Hi Cris,

    Thanks for your response.....that gets pretty close to what I want to achieve.

    Is there anyway instead of listing those email addresses in the condition that it can lookup to an excel file for the list of email addresses.

    That way I can have someone externally maintain that list and they don't need access to Jotform or the form buildler..

    The list of email addresses will change all the time...

    Regards

    Scott

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 25, 2014 at 07:31 AM

    Hi Scott,

    Thanks for your reply.

    I completely understand that you're looking for an easier way to manage your data and eventually update it without going to the form again. Unfortunately, that specific feature isn't available with Jotform. That might be a little complex since it would probably require special codes that reads external files which isn't part of the Jotform feature. However, if you know a little PHP programming, you may be able to achieve it when you download your form source code and implement it on the source code.

    Thank you.