How can I create a form that calculates the collective total value on form

  • Profile Image
    28061965F
    Asked on January 24, 2018 at 10:53 AM
  • Profile Image
    liyam
    Answered on January 24, 2018 at 12:07 PM

    Hello 28061965F,

    Unfortunately, there is no tool that can get the value of one submission and add the value to another submission. But you can download the submissions of your form into an excel document and you can then run a formula that will add the values of each. You can check out this guide to know how to get the Excel document of your form's submissions: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    If I am misinterpreting your inquiry, please let us know.

  • Profile Image
    Adrian
    Answered on January 24, 2018 at 02:07 PM

    If I understand you correctly, each question has a "value" and you want to add those values.

    You can use the Form Calculation Widget for that.

    Help Article: How to Perform Form Calculation Using a Widget

    I see that you have already turned on the option to use Calculation Values on the Single Choice fields.

    The next step is to add a Form Calculation widget and specify the questions you want to add.

    15168208292018-01-24 20_06_04.gif

    DEMO: https://form.jotform.com/80235417236957


    Let us know if you have further questions.

  • Profile Image
    Mike
    Answered on January 27, 2018 at 03:43 PM

    I have changed two fields in the calculation formula from the Text (A-Z) format to the Number (0-9) format, and added the + signs.

    Here is a quick animation:

    1517085157record.gif

    The calculation should be fixed.

    Unfortunately, there is no way to automatically assign the calculation values.

    Thank you.