How to populate info from pre-existing google sheet to jotform

We have a Jotform that is used by our client to accept membership renewals this form is working.

We now want to develop a Joform that will check a list of email addresses and confirm that the email address is on that list before allowing the remaining fields on the form to be completed.

There appears to be nothing within the existing Jotform capability to achieve this.

I am looking for a solution with the creation of a test form that can perform this look and check within the Jotform environment.

The email addresses will be maintained in a Google Sheet and will be updated online. So the Jotform needs to be able to "look" at the most recent copy of the Google Sheet when performing the validation.

Thanks

Abd

Hi Abd, 

We do not have an option to lookup an online sheet, but there would be an option to implement what you have shared in JotForm environment. You can create a conditional statement that would check the list of addresses and show form fields if there is a match. 

Basically, you need a statement of this format:

If FIELD contains comma separated list of addresses here then SHOW fields. 

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