- mijotAsked 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,
- JotForm SupportEltonCrisAnswered 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).
- TomAnswered 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?
- JotForm SupportBDAVIDAnswered on July 31, 2016 at 06:18 PM
@Tom, your inquiry will be addressed on the following thread: http://www.jotform.com/answers/894779-.