Google Spreadsheet: Separate each selected checkbox options into each column

  • Profile Image
    mijot
    Asked on April 19, 2016 at 09:55 AM

    I ran into this old post by searching for a solution to the same problem. I will share my workaround to this issue and also kindly ask the amazing team of developers at JotForm to come up with a solution to this very annoying problem.

    I often use jotforms to collect study data. These studies always have multi-select questions. What I have done is create hidden field and conditional logic for each of the options on a multi-select question to be able to write them on separate cells in the spreadsheet.

     

    Please consider the request,

    Cheers 

  • Profile Image
    EltonCris
    Answered on April 19, 2016 at 10:06 AM

    Again, thank you for sharing your workaround. I have escalated this as a feature request. I can't promise you anything but rest assured once this is added on Google Spreadsheet Integration, we'll let you know via this thread. 

    Just to ensure that I have understood it correctly, this is the image I added on the request ticket.

    By the way, you might also want to consider the workaround I've shared on this thread about separating stack data in a single cell into different columns (applicable for downloaded form submissions).

  • Profile Image
    Tom 
    Answered on July 31, 2016 at 04:26 PM

    I have a similar issue.  I have a scholarship application form with 20 scholarships.  Students choose a scholarship and fill out personal data.  I can allow them to check off multiple scholarships but their response shows up in one row and I cannot easily sort by scholarship.  If I limit them to only one scholarship choice per form, they are forced to retype all their personal information for every scholarship application.  Can this be avoided?

  • Profile Image
    BDAVID
    Answered on July 31, 2016 at 06:18 PM

    @Tom, your inquiry will be addressed on the following thread: http://www.jotform.com/answers/894779-