JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to get total of fields' values?Asked by Buzzcom on April 12, 2016 at 12:20 AM
Can someone please help me -
I have a form that I am happy with and the submission in spreadsheet will work.
What I would like to do is for the form to automatically add test 1 and test 2 fields together to give the totals.
I have calculations in other forms but I don't knwo how it works in how I have this one constructed. I need this one constructed like this so that it appears correctly in the submission spreadsheet.
I am sure there will be a way of achieving the result but I need some advice.
Thanks in advance,
As far as I understand from your question, you want to get the the total of the all "TOTAL" values from the "Dynamic Textbox" widget. To do that, you need to use the "Form Calculation" widget; but getting the infinite number of values from the widget is not possible. you simply can't add those numbers. So, you need to define a fixed amount of tests, then you can get the total value from them.
Once, you have add all the tests, you need to define the calculation on "Form Calculation" widget just like the below:
All the total values are coming from one test, so if you have 4 test, you need to add 4 total to the calculation. In addition, you can check the demo from the link below:
If you need any extra help, please do let us know.