The secret weapon that changed how I use Google Forms

Рет қаралды 12,231

Күн бұрын

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: 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: docs.google.com/forms/d/1lu7u...
* Regular Expression Library: regexlib.com
* 30 ways to use forms in the classroom: chrm.tech/forms
* Google Forms & Sheets for Educators: 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: Chrmbook.com
📕 Podcast: Chrmbook.com/podcast
🎙️ Book: http//:Chrmbook.com/book
🤝 Speaking and Consulting: SowashVentures.com/contact👉

Пікірлер: 7

@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!

@jrsowash Жыл бұрын

Yes, that is possible but would require some creativity to accomplish. You would probably need a combination of add-ons like form ranger and regular expression rules to make it happen.

@dyobetem Жыл бұрын

@@jrsowash thank you so much sir!

@eealliance5997 5 ай бұрын

That is possible by specifying the emails with regular expressions

@virgilpillay7089 9 ай бұрын

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?

@jrsowash 9 ай бұрын

I create a question that says "do you have another person to register" with a Yes/No box. Then I set that question up as a branch so that if they say Yes, it takes them to a second registration page, if they say no, it submits the form.

@virgilpillay7089 8 ай бұрын

Thanks for the reply@@jrsowash