How do you filter your mulitple choice responses?

  • Haribojones
    Asked on March 27, 2019 at 8: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..?


    Jotform Thread 1773381 Screenshot
  • Nik_C
    Replied 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!


  • Haribojones
    Replied 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
    ________________________________
    ...
  • Mike_G JotForm Support
    Replied on April 27, 2019 at 4: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 Screenshot 10

    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 Screenshot 21

    3. How it works.

    1556397943t16 42 Screenshot 32

    4. Result in the Google Spreadsheet.

    1556398030t16 46 44 Screenshot 43

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