Can check box inputs be downloaded into excel in separate columns?

  • Profile Image
    francoisuclan
    Asked on November 07, 2014 at 08:07 AM

    If a check box form is used with the option to tick multiple boxes when you download the submissions it generates all responses in a single cell in the excel file. 

    Is there a different method of input available that would allow the download to excel to be in separate cells for each check box ticked?

    Thanks in anticipation

  • Profile Image
    Charlie
    Answered on November 07, 2014 at 10:20 AM

    Hi,

    I'm not sure if I'm visualizing it correctly.

    If you have a question like,

    "What kind of pets do you have?"

    Checkboxes would be then:

    -Dog

    -Cat

    -Fish

    -Bird

    1. Example of the spreadsheet that would look like if checkboxes are separated by columns.

    1--> Yes

    0--> No

     

    I believe that this is not possible as the checkboxes hold the values of the text string named on them. And checkboxes that are not ticked would return a null or no value on the submission, which means it will not show in the excel sheet when downloaded.

    Here's an app that might help you, http://widgets.jotform.com/widget/configurable_list and http://widgets.jotform.com/widget/data_grid. You can explore on it by doing different setup. But for that specific setting that you are looking, I believe it's not possible right now.

    We can also create separate checkboxes that will act as a group, you can follow the screenshots below.

    1. You can also try creating separating checkboxes that are independent field but will act as a part of the group.

    2. This is how the submission will look like for separate checkboxes that acts as a group

    3. The downloaded excel sheet will then display the data like this:

     

    I hope this helps. Let us know if you need further assistance on this.

    Thank you.

  • Profile Image
    francoisuclan
    Answered on November 21, 2014 at 06:39 AM

    Thanks. As it stands, the data from the question below end up as a single line in Excel. If I can't resolve this to down in single columns, then I'll have to migrate back to Survey Monkey (which I'd rather not have to do).

    Any ideas?

  • Profile Image
    Charlie
    Answered on November 21, 2014 at 08:58 AM

    Hi,

    This is the workaround that I can think of right now. By adding checkboxes separately but will treat as one group.

    I have another sample form here:

    http://form.jotformpro.com/form/43243847975972 

    The result will show like this:

    For the above form, what I did is just add separate checkboxes, same with how I did in my previous post. But in this case, we want to have a column name "Choose a Plan" and the options "Plan A", "Plan B", "Plan C" and "Plan D" would be inside the cell. You can check the guide below on how I did this:

    1. Add a "Text" that will act as the Question for the checkbox options. Go to the properties of each checkbox.

    2. On the Properties window, add the text that will act as a column name and the option value.

    3. But the question on the properties will show as a label and will be visible in the form. What we can do is use a custom CSS code to hide the labels and the option names will be the only one visible.

    .form-label-top{

    display: none;

    }

    4. The form will look like this:

    5. The submissions on excel spreadsheet will then look like the one above.

    Let me know if this is what you have in mind.

    Thank you.