What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Can a report for question with a multiple choice answer put each answer in a separate column?

    Asked by Region25 on April 04, 2013 at 04:52 PM

    We have a fairly complex event registration form.  For different time slots during the weekend evemt, each participant selects which class they plan to attend.  Currently, when I download an Excel report of all submissions, each person's selection shows up in the column for that time slot.  We are trying to calculate class size for each class during a time slot.  Is it possible to have the Excel spreadsheet create a different column for each class during each time slot with a mark in the column for the class selected?

     

    Thank you for your help,

    Connie

    Page URL:
    http://form.jotform.us/form/21195312158146

    multiple choice Submissions event registration event registration form registration form size
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 04, 2013 at 05:43 PM

    Hi Connie,

    Sorry but its' not possible currently. There's a request about this but no updates as of the moment. Fields with multiple selections like Checkbox are compressed on a single column for now.

    May I suggest to try the Matrix fields? They appears to be different than using normal checkbox when exported to excel. Selections are separated each columns.

    Example

    Mark with blue box is the result using normal checkbox field. While the red one is using matrix field with check box inptus.

    Matrix tool is under "Survey Tools", FYI.

    Note quite sure if this works for you. You can give it a try if you like. Thanks!