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 separate data from checkboxes in reports?

    Asked by GuyPalinckxLS on October 03, 2016 at 03:29 AM

    HI,

    I'm using checkbox al the time with several options.  Sometimes more than 10.

    When somebody choose several options, the data in my report is stick to each other

    e.g.

    Checkbox with Monday, Thuesday, Wednesday, Thursday and Friday.

    When I choose Monday and Friday I'll find in my report in 1 cell : MondayFriday

    This is hard to filter data afterwards.

    Is there another solution that for each option the data is inserted seperated?

     

    Thanks in advance

     

    Guy

    checkbox different in find thanks solution
  • Profile Image
    JotForm Support

    Answered by Nik_C on October 03, 2016 at 05:33 AM

    Could you please explain a bit more with which kind of report you have this problem?

    I did a test with my form and values are not stick together. For example, they are in the same cell in spreadsheet:

    If you want those options to appear in separate cells I'm afraid that they will have to be a separate fields then.

    But please give us more information, maybe I misunderstood you.

    We'll wait for your response.

    Thank you!

  • Profile Image

    Answered by GuyPalinckxLS on October 03, 2016 at 05:56 AM

    Hi

    You understood it correctly as you have different options in one cell

    The problem is that I have more than 100 entries and I need to filter it

    e.g. as in your case, only options 4

    but "Option 4" will not be alone in the filter

     

    Thx

     

    Guy

  • Profile Image
    JotForm Support

    Answered by Nik_C on October 03, 2016 at 08:48 AM

    Thank you for clarifying, you can split text from the Excel column directly in Excel spreadsheet by using text-to-column feature. 

    I found this guide on how to do that:

    http://datapigtechnologies.com/blog/index.php/split-data-into-several-columns-based-on-carriage-returns/

    I'm afraid that data inputs from one field, like your checkbox with multiple options, will go to one cell in Spreadsheet because that's how the fields are linked.

    Hope it helps.

    Please let us know if you have more questions.

    Thank you!