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

    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?

     

    Thanks! Corey

    Page URL:
    http://realradioresearch.com/

    app Submissions survey JotForm thanks
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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!

  • Profile Image

    Answered by Verge on August 26, 2014 at 03: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

  • Profile Image

    Answered by Verge on August 26, 2014 at 04:18 PM

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

  • Profile Image
    JotForm Support

    Answered by jonathan on August 26, 2014 at 07: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.