How to split the check box values in different rows?

  • Profile Image
    L1H
    Asked 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
    david
    Answered 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.