in a check box, how to separate multi selection with a comma instead of CR

  • Profile Image
    unicefethiopia
    Asked on July 02, 2014 at 07:16 AM

    Hi, 

    I have a multiple selection checkbox in my form and would like to separate selected items with a comma instead of carriage return in the resulted excel sheet. Could you please advise how to realize this?

     

  • Profile Image
    jonathan
    Answered on July 02, 2014 at 09:08 AM

    Hi,

    Can you please clarify if this is the form http://www.jotformpro.com/form/41783554599976  you were working on?

    And if the checkboxes were this 

     

    And can you confirm that the comma separate option you wanted to do is in the downloaded Excel file or in the form itself?

    We will wait for your updates response.

    Thanks!

     

     

  • Profile Image
    unicefethiopia
    Answered on July 02, 2014 at 01:53 PM

    Yes, this is the form. We need the comma to be in the excel sheet. Thanks

  • Profile Image
    jonathan
    Answered on July 02, 2014 at 04:11 PM

    Hi,

    What you can probably do is used the Calculation Widget to capture the value of the checkbox field with comma separator.

    Try this steps:

    1. In your checkbox field ("This is a multiple application..."), click its property icon and add the options as the Calculation values in the field. See screen below

     

    2. Add a Calculation Widget into the form.

    3. In the Calculation widget, calculate the value of the check box field. Check the screen below how to and also the formula used.

     

    4. Saved.

    5. If all done properly the calculation should have similar result as this demo form http://www.jotformpro.com/form/41825680301954

    So, when you download the form submissions to Excel, the new field (result of calculation) should give the output of the check box with comma separator.

    Hope this help. Inform us if you need more assistance on this.

    Thanks!

     

     

     

  • Profile Image
    hraddisababa
    Answered on July 03, 2014 at 03:05 AM

    The calculation field looks a bit different than what you have. It only shows {result1} in the "Output". But in your case it shows something different. After testing, it only shows me a number each time an item is selected. Is there anything else I am missing?

    see my test form http://www.jotformpro.com/form/41702986259969

     

  • Profile Image
    ashwin_d
    Answered on July 03, 2014 at 07:14 AM

    Hello hraddisababa,

    You do not the the "Output" as displayed in my colleagues's screenshot because you added the field in your form calculation widget before checking the check box "Insert field as text instead of numeric.".  

    Please delete the formula from the form calculation widget and add it again. That should solve your problem. Please check the screenshot below:

    I cloned your form and did the changes. Please take a look at the following cloned form and see if this works as expected:  http://form.jotformpro.com/form/41833319229961? Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    unicefethiopia
    Answered on July 03, 2014 at 03:56 PM

    Thank you. This seems to be very tricky, but solved the problem !! 

  • Profile Image
    jonathan
    Answered on July 03, 2014 at 04:38 PM

    Hi,

    We are glad to know it works. 

    Contact us anytime should you need our assistance.

    Thanks!.

     

  • Profile Image
    gemai
    Answered on October 22, 2015 at 10:02 PM

    Hi

    I'm having the same issue but the forms are not accessible anymore. Can you help me?
  • Profile Image
    jonathan
    Answered on October 22, 2015 at 11:05 PM

    @ gemai 

    We will attend to your question here http://www.jotform.com/answers/688214

    Thanks.