Google Form calculation - App Script / Html / ...?

[Luca C.]

Hi,

I have a trouble with Google Form and I am trying to find a solution. 

In one section of my form I have various textbox (three in this esample https://forms.gle/rUS19EQzsGrJ8bB16) where I need to insert values. 

I want to make aritmetical operation with these values (like sum, average value, ...) and visualize result before going to the next section (e.g. if sum > x I can exit, if sum < x I need to go to the next section).

Is it possible to make calculation in Google Form? I have tried but it seems impossible to make dynamical calculation, so maybe is it possible with app script (gs / html)?

Thank you for your kindness

and

sorry for my english.

Best regards

Luca

[Clark Lind]

Yes, you will have to do this with HTML & javascript. There are no functions or methods that allow you to interact with the form while it is in someone's browser; apps script is interacting with the form as it exists on Google servers. So you have to wait until information is passed from the form back to Google where you have access to it. Using JS & html, that code is in the browser and you have some control over it.

[Luca Crétier]

Hi,

thank you for your help. In my case I need:

1) to sum ten numbers in one section of the google form;

2) if average value is less than another I can send form, otherwise I need to compile another section of the google form.

Do you have any advice / idea or example I can follow for a dialogbox html + js (form or sheets or other)?

Best regards

Luca

[Luca Crétier]

Hi,

I have find a good example

https://stackoverflow.com/questions/52914006/how-to-get-data-from-custom-dialog-window-in-google-app-script

Best regards

Luca