We need to create a form asking the clients for their age. Is there any way to create a field where you can only fill in numbers - maybe only 4 numbers like 1976 or 2011?

Another field input would be date. It would be perfect if I could limit the number - something like "not lower than 1800 and not higher than 2012" to prevent invalid numbers.

I can create a question with drop down list, but creating a list of all possible years would be stupid and uncomfortable to choose from.

3 Answers 3


Google Spreadsheet now takes into account Data Validation when submitting forms. So you can set a rule on your Age column to only allow numbers greater than 0.

When submitting a response which doesnt fit this rule the user is given this message: Oops...

I found out about it after reading this post.

  • 1
    thanks much. it helped. we also posted a request to improve this feature as it would be much better to limit the inserted value in the field directly ("This field allows only ..."). Current solution is not good for people submitting the form.
    – Juhele
    Jul 10, 2012 at 17:44

Google Forms now include proper Data Validation.


You could put a response validation on the input field that restricts the input to "Numbers," "Between," and then list the limits you mentioned, 1800 and 2012, and then choose your custom error text.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.