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 split the check box values in different rows?

    Asked by L1H on September 15, 2014 at 12:42 PM

    If a user fills out a check box question with more than one answer, all of the checked answers are grouped into the same cell in the submissions spreadsheet. That way, it is impossible to filter the submissions after individual entries for the check box question - only for that exact subset.

    Example:


    User A checks option 1 out of 7 possible choices. This choice shows up in the submissions as "1" in that cell.

    User B checks options 1, 2 and 4 out of 7 possible options.
    The submissions spreadsheet lists these choices as 


    1
    2
    4

    all in the same cell, with page breaks.

    If you wish to filter after users who have picked "1", you will only find User A. User B only shows in this filter if you filter after all users who picked 1, 2 and 4.

    My wish is either a possibility to filter these multiple choices after individual items - or a workaround for this.

    Thank you very much!

  • Profile Image
    JotForm Support

    Answered by david on September 15, 2014 at 01:58 PM

    Hi,

    I believe you have several threads with a similar question.  I went ahead and updated this one with a possible work around:

    http://www.jotform.com/answers/115035-Can-I-force-multiple-checkbox-selections-into-single-line-items-with-google-docs-integration#3

    Let us know if you have any further questions and we will  be happy to help.