The secret weapon that changed how I use Google Forms

Sdílet
Vložit
  • čas přidán 6. 08. 2024
  • 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👉

Komentáře • 7