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

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

    Asked by unicefethiopia 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?

     

    Page URL:
    http://form.jotformpro.com/form/41783554599976

    check Selection checkbox excel multiple selection
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by unicefethiopia 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
    JotForm Support

    Answered by jonathan 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

    Answered by hraddisababa 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
    JotForm Support

    Answered by ashwin_d 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

    Answered by unicefethiopia on July 03, 2014 at 03:56 PM

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

  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by gemai 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
    JotForm Support

    Answered by jonathan on October 22, 2015 at 11:05 PM

    @ gemai 

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

    Thanks.