The secret weapon that changed how I use Google Forms

There are an infinite number of ways that people can submit phone numbers, addresses, and other data into Google Forms, resulting in messy data that you have to clean up.

Response validation is a "hidden" feature of Google Forms that lets you establish rules for responses ranging from proper email addresses to consistently formatted phone numbers. You can even define custom rules using regular expressions!

Video Timeline:
0:00 Intro
0:44 Rules for email & response length
2:12 Enable response validation
3:55 Checkbox selection rules
5:14 "Password" validation rule
7:28 Create custom rules with regular expressions
11:55 Additional form resources

Additional links & resources:

Tags: #googleformstutorial #googleforms #regex #data #googleworkspace #teaching #assessment
-------------
John R. Sowash is a former HS biology teacher and principal who helps teachers use technology to improve instruction. You can pick up a copy of his book, read his blog, or invite him to come and visit your school.

[virgilpillay]

Great video. Any tips for creating a form where a teach or group leader has to register a group? Inputting the details, such as name, surname, department, age etc. Is it possible to do it without having to go back and register each individual as new response?

[dyobetem]

is it possible that only selected google mails can participate in a google form? ex: an examination that only selected user can take that exam and if his/her email is not on the list, it will direct him to an error page that he is not allowed or jump to another google form? thanks!