Say I have a Google form here: https://docs.google.com/forms/d/1HnATawk6ioE7_EVKrtszxvScjmUSF7_ma0_9XhBZ-hw/viewform
The user will input numbers.
As a confirmation before they submit the form, I'd like to use those numbers to display the analysis of the data which they can verify before submission. (To be precise, I'd like to display the sum of the first four numbers, then the sum of the next four numbers, then state which sum is bigger, and by how much.)
Is there a way to do this?
You are asking for creating dynamic data in Google Forms without clicking the submit button.
*This is not possible in Google Forms. Please have a look at the available triggers.
Since there can't be any triggers activated after the form is loaded, there can't be any interaction while filling and before submitting the form. Not even using a script.
Having said that, your other choice would be to use the HtmlService or the UiServise instead and build your own web application.