Which app I should use for submission data sorting?

  • Verge
    Asked on August 26, 2014 at 9:30 AM

    Hello. We have a fairly complicated form that we use a couple of times a year as a survey/data collection tool and usually get around 1,000+ submissions. With so much data and so many submissions, it's very time-consuming to sort through all of the data and add up the answers.

    I know JotForm has a slew of apps to connect to your form, and I'm wondering if/what apps would help me the most in sorting out all of this data when we run this survey?

     

    Thanks! Corey

  • Ashwin JotForm Support
    Replied on August 26, 2014 at 10:29 AM

    Hello Corey,

    There are lot of reporting options you may like to take a look at them:  http://www.jotform.com/help/chapter-6-Reports 

    I would suggest you please explain your requirement a bit more in details so that we can suggest a good solution.

    If sorting is the only issue you are having, I believe excel spreadsheet is the right answer. You will be able to sort, add your own formula to filter the submission data from an excel spreadsheet. The following guides should help you:  http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel 

    http://www.jotform.com/help/101-How-to-create-an-Excel-Report 

    You may also like to take a look at the following apps as well:

    Formalytics:  http://apps.jotform.com/app/formalytics 

    Submission View:  http://apps.jotform.com/app/submission_view 

    Do get back to us explaining your requirement a bit more in detail.

    We will wait for your response.

    Thank you!

  • Verge
    Replied on August 26, 2014 at 3:13 PM

    Hi, thanks for the response. I just talked with my guy who will be doing all of the data sorting, and realized the main issue that is so time consuming, is that when we have a survey question with multiple checkbox options, and an individual chooses 2, 3, 4 options from the checkboxes, it puts all of those answers into 1 column instead of creating columns for each checkbox option.

    I realize we could try to break the cell in Excel, but but the answers are not comma separated, and some of the options contain more than 1 word, so it's not quite that easy. 

    Does that make sense? Do you know of an easy way to sort that straight from JotForm, or could one of these apps potentially help with that?

    Here is a screenshot of a spreadsheet that has a column with multiple checkbox answers. It separates the answers with <br> tags?

    Thanks! Corey

  • Verge
    Replied on August 26, 2014 at 4:18 PM

    Screenshot: https://www.evernote.com/shard/s49/sh/3aea2039-950e-4324-9086-9befeab8afba/828748616515713ed9afa2a8f62d2989

  • jonathan
    Replied on August 26, 2014 at 7:56 PM

    Hi,

    That is correct. The data of checkbox field is contained into a single cell/column.

    The name of  the checkbox field is being used as the header/column name.

    In the Excel result, you can create a separator for the data in the checkbox using the Excel function Text To Column -- the data in Checkbox is using carriage return (new line) as the separator.

    Please check this article on how to do it in Excel.

    Hope this help. Inform us if you need more assistance.

    Thanks.