Validating email addresses in Google Forms

google-apps-script google-forms
andyg1 picture andyg1 · May 18, 2012 · Viewed 38.2k times · Source

I want to use a Google Form to populate a Google Spreadsheet. One of the fields is email address, and I need to validate this against the list of emails for our organisation - in other words forcing people to use valid and existing email addresses.

Our organisation uses Google Apps. The form will be created by a user who is in our organisation and only email addresses from our organisation/domain will be considered valid.

Answer

Romias picture Romias · May 28, 2014

Now you can put a Regular Expresion in the field:

For EMAIL:

[a-zA-Z0-9_\.\+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-\.]+

Related questions

Google Forms file upload complete example

How do I allow my viewers to use Google Forms to upload some files to my form and save it to my Google Drive? I am looking for a complete example: It must tell what code to add to the …

Read More
Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question will be 'prefilled' with …

Read More
Google Form API?

I would like to (programmatically) convert a text file with questions to a Google form. I want to specify the questions and the questiontypes and their options. Example: the questiontype scale should go from 1 to 7 and should have the label …

Read More