The secret weapon that changed how I use Google Forms
John R. Sowash John R. Sowash
45.2K subscribers
10,160 views
0

 Published On Dec 6, 2022

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!

👉 Note: view this form while watching the video: https://tinyl.io/7TZY

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
9:54 Using RegExLib.com
11:55 Additional form resources

Additional links & resources:
* Make a copy of my demo form: https://docs.google.com/forms/d/1lu7u...
* Regular Expression Library: http://regexlib.com
* 30 ways to use forms in the classroom: http://chrm.tech/forms
* Google Forms & Sheets for Educators: https://www.chrmbook.com/courses/form...

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.
✏️ Blog: http://Chrmbook.com
📕 Podcast: http://Chrmbook.com/podcast
🎙️ Book: http//:Chrmbook.com/book
🤝 Speaking and Consulting: http://SowashVentures.com/contact👉

show more

Share/Embed