Teaching Tip: Validating Google Form Answers
July 16, 2014
Google Forms have so many great uses, both inside the classroom and as a productive
administration tool. The power of Google Forms comes in the collection of responses
into a Google Sheet that has basic evaluation capabilities similar to Microsoft Excel.
When you want the responses to be in a specific format, you might have to apply validation
rules. In Google Forms, you can set validation criteria for checkbox, text and paragraph
text form fields. Each type of question validation has different settings. You can
use regular expressions to help define what kind of data is acceptable. Validation
looks for a specific pattern of data that is entered by users and aids in your analysis
once the results are collected.
Checkbox question types
The validation setting for checkbox questions allow you to require a specific number
or range of numbers from options that users select. If you ask for a specific number
of questions to be answered or if you allow for a range of checkboxes, you can choose
鈥淪elect at least," 鈥淪elect at most鈥 or 鈥淪elect exactly鈥 from the dropdown menu. Don鈥檛
forget to enter some error text so users get an idea of why their entry might be denied
if they don鈥檛 follow your directions.
For example, let鈥檚 say you want users to select three of four options. Choose the
鈥淪elect exactly鈥 option and then put the number 鈥3鈥 in the next field. Enter error
text like, 鈥淵ou must select 3 of the 4 options.鈥
Text question types
The validation settings for text questions allow you to use numbers, text or regular
expressions as validation tools. Within each of the validation settings there are
multiple options for defining acceptable responses in order to further define the
acceptable answers from your users.
For example, let鈥檚 say you want to ask users to enter their preferred phone number
using dashes between the three sets of numbers. Choose 鈥渞egular expression鈥 and 鈥渕atches鈥
from the drop-down menus. Enter 鈥淾\d{2}-\d{3}-\d{4}$鈥 into the pattern field.
If users don鈥檛 use a dash, then their input will be denied.
Options for paragraph question types are similar to text question types, with the
exception of the option to set number validation.
-- Teaching Tip by , Learning Design coordinator at 性欲社 eLearning
For more information about using validation in Google Forms, .