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.
You can use operations in your Spreadsheet template. Here is an article on how to do calculations on a spreadsheet template.
If you have any questions, contact email@example.com, we are here to help!
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.