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.


  • Profile Image

    How to change excel output of Grading survey tool

    Asked by jyeyeuhsia on May 12, 2013 at 02:41 PM

    Hi Development Team,

    I like using the grading survey tool. Especially how it calculates the total sum of all the values. However, when the submission is reported into excel format, I don't like that all the options are in one cell. Is there a way to split up all the options so that they will be reported into individual cells in excel? For instance, the label of each option will be in columns and their corresponding values will be in rows.

    Thanks,

    SK

    Page URL:
    www.google.com

    Screenshot
    survey excel grading tool
  • Profile Image
    JotForm Support

    Answered by jonathan on May 12, 2013 at 06:14 PM

    Hi,

    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.

    Thanks.


  • Profile Image

    Answered by jyeyeuhsia on May 13, 2013 at 02:04 PM

    Thanks Jonathan,

    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.

    SK

  • Profile Image
    JotForm Support

    Answered by jonathan on May 13, 2013 at 04:45 PM

    Hi SK,

    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.

     

     

  • Profile Image

    Answered by jyeyeuhsia on May 13, 2013 at 06:14 PM

    Hi Jonathan,

    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.

    Best,

    SK

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 14, 2013 at 03:16 AM

    Hi,

    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!