Google Forms – Check Data Entry Consistency

google-forms

In the questionnaire I'm working with, there's a question like this:

  • What was your facility's total revenue last year?

And a bunch of following questions asking about sources of that revenue, e.g.:

  • Of which, how much came from sales?
  • Of which, how much came from services?

etc.

Is there a way in Google Forms to ensure data entry consistency for questions like this? For example, at the end of entry of individual sources of revenue, if those sources don't add up to be equal to total revenue, there will be a pop-up message, e.g., "Data entry inconsistency. Please ensure that individual sources add up to be equal to the total revenue." The respondents can choose to "Return" to start again from the Total revenue field, or to "Proceed anyway", acknowledging that there's some issue with their data quality.

Best Answer

Google Forms doesn't incluye a way to validate consistency across several responses before submitting the form.