How can I create a form that calculates the collective total value on form
- 28061965FAsked on January 24, 2018 at 10:53 AM
- JotForm SupportliyamAnswered 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.
- JotForm SupportAdrianAnswered 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.
DEMO: https://form.jotform.com/80235417236957
Let us know if you have further questions.
- JotForm SupportMikeAnswered 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:
The calculation should be fixed.
Unfortunately, there is no way to automatically assign the calculation values.
Thank you.