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

    Check Box options in separate excel columns

    Asked by yodacsmith on February 14, 2012 at 06:11 AM

    Hi

    I use tick boxes to allow people to choose their available dates. When they submit the dates are concatenated together, whereas I would like them as sepearte columns for each date in the CSV report. Is there anyway I can do this - or do I need to use a separate control?

    Thanks

     

    Pete

     

    Page URL:
    http://www.jotform.com/form/20155038293

  • Profile Image

    Answered by fxr on February 14, 2012 at 07:27 AM

    Hello Pete,

    Yes, you are going to have to use a seperate checkbox field for each of your possible dates to be able to have them on seperate columns in your CSV.

    If you need to add labels to each of your date fields to aid the usability of the csv file, add them; we can suggest some custom CSS you can use to hide the labels on the form itself. 

    We should also be able to provide some CSS to bring each of your checkbox fields closer together. 

    To begin with, I would concentrate on reconfiguring your form priotising getting your CSV download looking/functioning correctly; most form display issues can be resolved with some CSS which would are happy to help with.

  • Profile Image

    Answered by sjakubik on January 16, 2013 at 09:54 AM

    FXR,

    I am having the same issue as Pete, and I thought that I did put them in separate fields.  What do I need to do differently? Thanks! Susanna

    http://jotformpro.com/form/23533828855968

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on January 16, 2013 at 10:14 AM

    @sjakubik 

    can you please clarify what it is that you are looking to achieve?  We'll be glad to assist you!

  • Profile Image

    Answered by sjakubik on January 16, 2013 at 10:37 AM

    Sure! :) This form has checkboxes, and when I download the report if they have selected two options, they are in the same column with the return between them. The CLEAN function doesn't really help; how do I set up the form so that the data from different check boxes will go into different columns? Thanks! Susanna

     

     


  • Profile Image

    Answered by sjakubik on January 16, 2013 at 10:45 AM

    If I download my report as a CSV file instead of an Excel file the carriage return will go away, but I still will have two responses concatenated together. How do I set up my form so that if they select the  "football" and "baseball" checkboxes, football will be in one column and baseball will be in another in the report? Thank you so much!

    Susanna

  • Profile Image

    Answered by jeanettebmz on January 16, 2013 at 12:03 PM

    Hello Susanna

    You can use separate checkboxes as explained by FXR, just leave the label for the first checkbox and write only one option for each checkbox

     

    If you still need assistance, please open a separate thread

  • Profile Image

    Answered by sjakubik on January 16, 2013 at 04:40 PM

    I get it now. :) Thank you so much!

  • Profile Image

    Answered by anjaba on February 19, 2013 at 04:14 PM

    FXR, can you provide the CSS code you mentioned that will bring radio button columns closer together?

  • Profile Image
    JotForm Support

    Answered by Mike_T on February 19, 2013 at 04:29 PM

    @Anjaba,

    The CSS code depends on your form fields and layout. Please simply create a new forum thread, provide us with the link to your form, and we will be happy to help you.