How do you filter your mulitple choice responses?

  • Profile Image
    Haribojones
    Asked on March 27, 2019 at 08:47 AM

    How do you get your multiple chice responses to be in seperate cells on a google sheet? So you can filter them individually..?


    Screenshot
  • Profile Image
    Nik_C
    Answered on March 27, 2019 at 10:51 AM

    I'm afraid you cannot, since multiple choice field is still one field, just with multiple options, so as it is, it is represented as one field in Spreadsheet as well.

    You could break it in multiple checkbox fields in order to do so, but this will cause that each checkbox field is a separate field in submissions page as well, since that's the way to have it separate in Spreadsheet.

    Hope it helps.

    Let us know if you have any further questions.

    Thank you!


  • Profile Image
    Haribojones
    Answered on April 27, 2019 at 11:43 AM
    I have to say as your main function as an online form generator it seems like having a multiple choice option, especially advertised as a new feature, that you cannot separate and filter out is ridiculous..... In fact, it has actually created a lot more unnecessary work and frustration...
    I heavily suggest that you look into rectifying this as I'm sure many other customers will be feeling the same.
    I look forward to any updates in this area.
    Kind Regards
    Harry Jones
    The Social Project Manager
    07403 119106
    ________________________________
    ...
  • Profile Image
    Mike_G
    Answered on April 27, 2019 at 04:47 PM

    I see that you have opened a separate thread regarding your concern which one of my colleagues provided you a workaround that you can do to achieve your requirements.

    You may also try the same workaround with Google Spreadsheet — https://support.google.com/docs/answer/6325535?co=GENIE.Platform%3DDesktop&hl=en

    There is another workaround where you can create the options in the Multiple Choice field into separate fields on the form. The fields can be Multiple Choice fields or Single Choice fields. Then, you will create a condition that will fill in the fields if the option they represent in the original Multiple Choice field is selected. To better understand what I'm trying to explain, please refer to the screenshots below.

    1. Setting up the form. You can have the additional Multiple Choice fields hidden on the form so it would not be shown to your respondents. How-to-Hide-Form-Fields


    1556397120t16_29_35.png

    2. Create a condition that will fill the option of the additional Multiple Choice field if it was selected from the original Multiple Choice field.

    1556397556t16_33_57.png

    3. How it works.

    1556397943t16_42.gif

    4. Result in the Google Spreadsheet.

    1556398030t16_46_44.png

    I hope this helps. If you have other questions or concerns, please do not hesitate to let us know.