You can create rules that people have to follow when they fill out your form. For example, if you ask for email addresses, you can make sure that people can only submit properly formatted email addresses.
Set up rules for a question
- Open a form in Google Forms.
- Click Add .
- To the right of the question title, choose the type of question. Learn more about types of questions.
- To set up rules, click More .
- Click Response validation.
- To set up a rule select first the type of rule you want. The rule options available depend on the type of question chosen.
- Optional: To add an error message, on the right, in the “Custom error text” field, enter an error message. Responders will get this message when their answer doesn’t follow the rules.
- Example: You reached the limit of 200 words.
Types of rules
Each question type has different settings options.
- Number: To ensure the answer contains a certain number, in the drop down menu, select Number. Then, select one of the options for your rule.
- Examples:
- A number greater than or equal to 50
- A number between 21 and 42
- Text: To ensure the answer contains certain text, in the drop down menu, select Text. Then, select one of the options for your rule:
- Example: Make sure that answers contain the word "candy.”
- Make sure the response is in email format [email protected].
- Example: Make sure that answers contain the word "candy.”
- Length: To set up a maximum or minimum character count for your answer, in the drop down menu, select Length. Then, select Maximum or Minimum character count, and the number.
- Example: Limit answers to 500 characters or require at least 200 characters.
- Regular expression: To require text answers to match certain formulas that you choose, select Regular expression. Then select one of the options in the drop down menu (Contains, Doesn’t contain, Matches, Doesn’t Match) and add the pattern. Learn more about regular expressions.
- Example: Response must be a 10-digit phone number, where the range for each digit is 0–9.
- Input: Regular expression Matches
[0–9]{10}
- Expected result: 1234567890
- Input: Regular expression Matches
- Example: Response must be a 10-digit phone number, where the range for each digit is 0–9.
- Length: To set up a maximum or minimum character count for your answer, in the drop down menu, select Length. Then, select Maximum or Minimum character count, and the number.
- Example: Limit answers to 200 characters.
- Regular expression: To require text answers to match certain formulas that you choose, select Regular expression. Then select one of the options in the drop down menu (Contains, Doesn’t contain, Matches, Doesn’t Match) and add the pattern. Learn more about regular expressions.
- Example: Response must be a 10-digit phone number, where the range for each digit is 0–9.
- Input: Regular expression Matches
[0-9]{10}
- Expected result: 1234567890
- Input: Regular expression Matches
- Select at least: Set a minimum number of boxes that can be checked.
- Select at most: Set a maximum number of boxes that can be checked.
- Select exactly: Specify the number of boxes that must be checked.
In multiple choice grid questions responders can only choose one column per row.
To set up your question:
- In Google Form, click Add .
- Add your question to the “Question” field.
- To the right of the question title, choose Multiple choice grid .
- Add the options for the rows. For example: A, B, C.
- Add the options for the columns. For example: 1, 2, 3.
To custom your question you can setup these options:
- To make sure responders choose an option from each column, turn on “Require a response in each row.” If they don’t, they get an error message and can’t continue. See how to set up an error message.
- To limit answers to one choice per column:
- At the bottom right, click More .
- Check the box next to “Limit to one response per column.”
- To shuffle the row order every time the survey is open:
- At the bottom right, click More .
- Check the box next to “Shuffle row order.”
Example of “Limit to one response per column”
Input:
- Rows: A, B, C
- Columns: 1, 2, 3
Result: Responders can choose one row item (A, B, C) for each column (1, 2, 3). If they check multiple rows in a column, they get an error message.
In multiple choice grid questions responders can only choose one column per row.
To set up your question:
- In Google Form, click Add .
- Add your question to the “Question” field.
- To the right of the question title, choose Checkbox grid .
- Add the options for the rows. For example: A, B, C.
- Add the options for the columns. For example: 1, 2, 3.
To custom your question you can set up these options:
- To make sure responders choose an option from each column, turn on Require a response in each row. If they don’t, they get an error message and can’t continue. See how to set up an error message.
- To limit answers to one choice per column:
- At the bottom right, click More .
- Check the box next to “Limit to one response per column.”
- To shuffle the row order every time the survey is open:
- At the bottom right, click More .
- Check the box next to “Shuffle row order.”
Example of “Limit to one response per column”
Input:
- Rows: A, B, C
- Columns: 1, 2, 3
Result: Responders can choose one row item (A, B, C) for each column (1, 2, 3). If they check multiple rows in a column, they get an error message.
Regular expressions
You can require answers to match a particular set of criteria called regular expressions. Regular expressions search for patterns in the answers.
Important: If you search for instances of a character that has a specific meaning in regular expressions, you should place a backslash in front of the character when you enter your search. For example, if you want to search for an instance of the $ character, you should enter: \$
.
This table shows some of the expressions that Google Docs supports. There are many other supported expressions you can use.
Expression | Description | Example | Matches | Does not match |
---|---|---|---|---|
. | A period signifies any character in the given position. | d. | do, dog, dg, ads | fog, jog |
* | An asterisk after a character signifies a search for that preceding character repeated zero or more times. | do*g | dog, dg, dooog | dOg, doug |
+ | A plus after a character signifies a search for that character displayed one or more times. | do+g | dog, dooog | dg, dOg, doug |
? | The previous expression is optional. | do?g | dg, dog | dOg, doug |
^ | A caret must be placed at the beginning of a regular expression and signifies that the string starts with the character(s) or sequence placed after the caret. | ^[dh]og | dog, hog | A dog, his hog |
$ | A dollar sign must be placed at the end of a regular expression and signifies that the string ends with the character(s) or sequence placed before the dollar sign. | [dh]og$ | dog, hog, hot dog | dogs, hog, doggy |
{A, B} | The previous expression is repeated between A and B times, where A and B are numbers. | d(o{1,2})g | dog, doog | dg, dooog, dOg |
[x], [xa], [xa5] | A character set indicates that just one of the given character(s) should occur in the current position. For the most part, any characters are valid within brackets, including characters mentioned previously in expressions: [xa,$5Gg.] | d[ou]g | dog, dug | dg, dOg, dooog |
[a-z] | A character set range signifies a search for a character within the given range of characters. Common ranges include a-z, A-Z, and 0–9. Ranges can be combined into a single range: [a-zA-Z0-9]. Ranges can also be combined with character sets (mentioned previously): [a-zA-Z,&*]. | d[o-u]g | dog, dug, dpg, drg | dg, dOg, dag |
[^a-fDEF] | A character set beginning with a ^ signifies a search for a character that isn't within the given set. | d[^aeu]g | dog, dOg, dig, d$g | dg, dag, deg, dug |
\s | Any white space character. | d\sg | d g, d[TAB]g | dg, dog, doug |
Below are a couple of examples of how regular expressions could be used to search a spreadsheet:
-
Search for cells that contain dollar amounts
-
Enter the following in the Find bar:
^\$([0-9,]+)?[.][0-9]+
-
This means a dollar amount where the first number is any number 0–9 or comma occurring zero or more times, followed by [.], followed by any number 0–9 repeated one or more times. This search would return any of the following: $4.666, $17.86, $7.76, $.54, $900,001.00, $523,877,231.56
-
Search for cells that contain US zip codes
-
In the “Find” bar, enter:
[0-9]{5}(-[0-9]{4})?
-
This means a U.S. zip code consisting of five numbers with an optional hyphen and four-digit add-on.
-
Search for cells containing names beginning with a lowercase letter
- Enter the following into the Find bar:
^[a-z].*
- Enter the following into the Find bar:
This means a cell input that contains a lowercase letter followed by another character 0 or more times. This search would return any of the following: bob, jim, gEORGE, marTin