How to get total of fields' values?

  • Buzzcom
    Asked on April 12, 2016 at 12:20 AM

    HI,

    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,

    Michelle

     

    https://www.jotform.com/?formID=61018086892864

     

  • mert JotForm UI Developer
    Replied on April 12, 2016 at 4:42 AM

    Hi Michelle,

    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:

    How to get total of fields values? Image 1 Screenshot 20

     

    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:

    https://form.jotform.com/61022584528959

     

    If you need any extra help, please do let us know.

    Regards.