I would like to be able to do calculations on the data in my form and have them show up in the published form.
My form asks for data. I would iike to be able to do calculations on that data and include the answers in the published form. I can get the sheet to do the calculation, i'm not sure how to get the information out into the template.
Tim W commented
If you use a spreadsheet as the template, it can do calculations with the data that is submitted.
I've been trying to create an invoice like this for hours.. I decided to just calculate & input the total, manually.. would be a very useful feature for many use cases.
There are currently 2 triggers in form-scrpts: 'on load' and 'on submit'. What would be nice order to solve what R flynn is asking about, is a trigger for 'on form fieldset answer/option-select/input' (or something like that) - so that a script (that adds values from multiple form fields) gets triggered as soon as those values have been selected/input.