Remember that the goal when collecting information is to collect valid, accurate information. In the same way that we can add validation to Access tables and Forms, Google Forms offers various techniques to facilitate the collection of accurate data in terms of question types and validation. I recommend making questions requiring personal information optional; many people are concerned about their privacy and forcing people to provide their personal details (name, e-mail address etc) may result in them abandoning your questionnaire.
This post is an extension of the post: Google Form PAT questionnaire. In this post:
Validation rules assist in guiding the respondent in filling out the Form correctly and will prevent the Form from being submitted with incorrect data.
1. Short answer
In the below example, a question for Age is added using the Short answer question type. Suitable validation is added to ensure that the respondent can only enter an integer value as their answer:
- Add question text
- Select the Short Answer question type
- Click on the menu
- Select the Response validation option
- Select a validation type
- Select a validation rule
- Input a value
- Add an (optional) error message
2. Multiple choice
In the second example, a multiple choice question for Gender is created. The Multiple choice type results in a set of radio buttons ensuring that the respondent can only select one option:
- Select Multiple choice as the question type
- Enter the question text
- Google Forms intelligently suggests a set of options based on the question text; select the Add All option
- Edit the text if required
- Delete an option if required
- Set question to Required
A set of Checkboxes can be used for a respondent to select one or more (or no) options. There is also a setting that allows the respondent to add their own option. In the example below I have added validation (and because the requirement for answering the question is not so simple, I added an instruction below the question text).
Observe in the After image below what happens when the validation rule is broken: the validation text you entered appears in red and the outline of the entire question fieldset turns red.
- Select Checkboxes as the type of question
- Add question text
- Add an instruction
- Type your options one at a time where it says “Add option“
- Add an “Other…” option
- Add validation:
- Enter the digit 2 to limit the respondent to 2 selections
- Add validation text
4. Linear Scale
Use the Linear Scale type when asking a question such as “On a scale of 1 to 10…”.