Lookup List for eMail addresses before Download

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

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!

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

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.