Hope to make this one live. :)

Hope to make this one live. :)

Originally shared by Trevor Beck

Advanced Google Forms Validations - Education on Air

Why spend time cleaning up the data in the spreadsheet when you can force your users to do it right in the first place?

As part of Google's Education on Air, I'm running a session called Google Forms Validations where I'm going to show you how to create your own validations using regular expressions. This is great when you want to ensure the data is formatted properly when entered. For example:

• Phone numbers as xxx-xxx-xxxx
• Postal codes (ensuring letters are capitalized): T5J 4S2
• Emails from a specific domain: johndoe@here.com.
• Course numbers (capital letters): ACCT101

You can sign up for my session here: https://goo.gl/lYy21h

Be sure to check out what other sessions are being offered for free at https://educationonair.withgoogle.com