-
28061965FAsked on January 24, 2018 at 10:53 AM
-
liyamReplied 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.
-
28061965FReplied on January 24, 2018 at 1:26 PM
Hi Iiyam,
Actually i was trying to add the values of one submission. I have 300 plus questions in groups and most have an option of 1 to 4 click selections. I am trying to calculate how many total clicks to answer 1 - 2 - 3 and 4, in each section.
if that explains it any better ?
-
AdrianReplied on January 24, 2018 at 2: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.
-
28061965FReplied on January 27, 2018 at 11:53 AM
Adrian Thanks as again this is very helpful.
Ok, so I've set up and test my first 20 questions out of over 300 just to make sure I understand things.
If you could take a look there seem to be a glich on my question 17. all the rest of the responses match the values I have set up but not question 17.
Also. As you can see I get a list of the value ie : 11111110033 etc. it is not adding such as 1+1+1+1 etc to give me the combined score, any ideas here?
Also the bit that takes time is put the value scores in 0 1 2 or 3 one by one and I need to do this for another 300 questions, any magical answers ?
thank you so much you guys are really helpful Christine
-
MikeReplied on January 27, 2018 at 3: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.