JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Which app I should use for submission data sorting?Asked by Verge on August 26, 2014 at 09: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?
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
You may also like to take a look at the following apps as well:
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.
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?
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.