Check Box options in separate excel columns

  • Profile Image
    yodacsmith
    Asked 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

     

  • Profile Image
    fxr
    Answered 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
    sjakubik
    Answered 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
    EduardoMendez
    Answered 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
    sjakubik
    Answered 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
    sjakubik
    Answered 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
    jeanettebmz
    Answered 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
    sjakubik
    Answered on January 16, 2013 at 04:40 PM

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

  • Profile Image
    anjaba
    Answered 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
    Mike_T
    Answered 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.