What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Unfortunatelly, you cannot do this on the Excel download process. As you cannot break individualy during submission each element of the Grading tool.
BUT what you can try doing is use the CSV format in the Notification email. Use the text mode of the email notification so that the message can be parse as CSV formatted data, and then the CSV data can be imported to Excel.
Here is a test form http://www.jotformpro.com/form/31317156931956
use your email so that you can recieved the sample data in the autoresponder email.
Hope this help. Please inform us if you need further assistance.
This is a great idea, thank you. But unfortunately, I would like for all the submissions of this form to propagate into one excel sheet. And preferably, I would like to streamline the whole process such that I would not have to do any importing or exporting. That way, I can have a non-technical staff member to open one excel file and all the data be there. Your advice will be much appreciated.
Thanks in advance.
I agree with you on the streamlined process.
We can submit a request feature ticket to our next level support about this. A capability within the form builder to split the output of the Grading tool elements in submission or Excel downloaded data.
But I'd also like to tell you in advance, that feature request have to pass approval process and when approved, can also take some time to be developed.
Another option that I can suggest is to use individual number field (from quick tools) instead.
Although this will not give you the sum/average display on the form like the Grading tool, it will be a separate fields/column when you download the submission to Excel or even when integrated to google spreadsheet.
A fix formula on the Excel or Spreadsheet should provide you a column for sum/average of each elements or number field.
Inform us if you have further inquiry.
Thanks again for the quick reply, and I really appreciate the efforts. My first consideration was actually to use the number field and use excel to sum it up as you've suggested, but I like the sum/average display for the user. I want the user to see their sum/average so that they can visualize the total of the values they are inputing without having to do math in their heads. This is especially helpful when there are several fileds that needs to sum up to a specific value.
Thanks again for suggesting the work-arounds. From time-to-time, I'll keep an eye for any updates from the development group.
I have another workaround for you which I hope you'll like, though this requires a little manual process on Excel Application. Check out this thread: http://www.jotform.com/answers/214003
Hope this helps. Thank you!