-
VergeAsked 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
Page URL: http://realradioresearch.com/ -
Ashwin JotForm SupportReplied 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!
-
VergeReplied 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
-
VergeReplied on August 26, 2014 at 4:18 PM
Screenshot: https://www.evernote.com/shard/s49/sh/3aea2039-950e-4324-9086-9befeab8afba/828748616515713ed9afa2a8f62d2989
-
jonathanReplied 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.