Google-forms – Google Forms Answer Validation Based On Another Previous Given Answer

data validationgoogle-forms

I am working on a form in Google Forms.

At some point during my form, I need to validate an answer based in a previous answer.

To make it more clear, I give you an example:

  1. How many hours do you work per day?
    30
  2. How many of those hour do you use conference calls?
    40

This should return an error. Because the answer in 2. must be equal or less than answer in 1.

Is there anyway of doing this kind of validation?

Best Answer

At this time Google Forms doesn't include a way to extend the form respondent view by any means including the use of custom HTML/CSS/JavaScript.

One alternative is to do the validation after the response was submitted by using Google Apps Script. This validation could log the validation result by changing a form response value, editing another file like a spreadsheet or online database.

A more radical alternative is to use other app to create your form like the Google Apps Script HTML Service, Google App Maker (but this only works for internal use of G Suite organizations), among other apps.

Related Topic