- jyeyeuhsiaAsked on May 12, 2013 at 02:41 PM
Hi Development Team,
- JotForm SupportjonathanAnswered on May 12, 2013 at 06:14 PM
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.
- jyeyeuhsiaAnswered on May 13, 2013 at 02:04 PM
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.
- JotForm SupportjonathanAnswered on May 13, 2013 at 04:45 PM
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.
- jyeyeuhsiaAnswered on May 13, 2013 at 06:14 PM
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.
- JotForm SupportEltonCrisAnswered on May 14, 2013 at 03:16 AM
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!