How to add a simple calculated field to a google form?
I'm looking for a way to add simple calculated field in a google form that will be dependent on other field's values.
The first field is a simple price field quantity * price = total_price where quantity is a numeric field entered by the user.
The second field is an end date now() + X months where X is selected by the user.
I'v taken a look at google's tutorials and found only addons which in my understanding are form wide where i'm looking for something more like a custom form field.
The best solution would be one that would calculate the fields as the user change the other input's value but a simple text in the confirmation page is also OK.
I would appreciate if anyone could point me in the right direction. Thanks.
Answer
Scripting only can affect the creation and post-submit processing of a form. You cannot make any changes to the "live" form the user is currently looking at. What you can do is send an email to the user after the form has been submitted with a calculated summery. You could include a link to the getEditResponseUrl() if they see any errors.