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

    Excel File Submission: Better display of selected items in a check box field in the spreadsheet

    Asked by ts9964 on September 22, 2015 at 04:23 PM

    I have created a form to ask people to click the areas that apply, but on the spreadsheet these cannot be filtered separately. what is the best way to add buttons to give each answer on a separate column?



    This is a re-post of a comment on How to create your first web form

    separate column separately spreadsheet
  • Profile Image
    JotForm Support

    Answered by jonathan on September 22, 2015 at 05:45 PM

    I checked your account/username ts9964  but so far I see that there was no form under your account.

    Can you please share to us the URL of the form you have the issue?

    We will be able to provide the appropriate suggestion/response if we can check the form itself.

    We will wait for your updated response.

     

    Thanks.

  • Profile Image

    Answered by ts9964 on September 24, 2015 at 03:34 AM

    The form is within my managers log in, I believe.  The location is:

    https://www.jotform.com//?formID=52161858494363

    if this helps.

    I have been playing with it to try to get a click box for each element, as I need to be able to filter the information to know which individual likes to do which activity.

     

    Currently the spreadsheet filters on the subheading and clumps all the answers together.  I am sure there will be a way to do this as the system is fabulous and easy to use (for me as a technical dinasaur).

     

    Many thanks for your help

  • Profile Image
    JotForm Support

    Answered by Charlie on September 24, 2015 at 11:21 AM

    Hi,

    Unfortunately, the check boxes will output the answers in one column.

    However, I was able to replicate a different problem, in the excel file the answers in the check boxes are not separated by anything, hence, it shows like this:

    Which is hard to filter. You can try downloading a CSV file of the submission, that will give you a proper delimiter that will separate the options selected. You can then use a Filter function 

     

    I will still forward this to our developers to have it checked and see if they can give a better output on an excel file submission, I have also note that you would the items selected in separate columns. Unfortunately, I'm unable to guarantee that the changes will be implemented anytime soon. But will update you on this thread as soon as we hear any news.

    Thank you.

  • Profile Image

    Answered by ts9964 on September 24, 2015 at 01:47 PM
    Thank you I will check the CSV option tonight.
    Many thanks
    Tracy Small (ts9964)
    ...
  • Profile Image

    Answered by ts9964 on September 30, 2015 at 04:47 AM
    Thanks Charlie,
    I have checked the CVS file and this is the same. When the development solution is available I will try again. It would be helpful to have a subject with yes / No option for a single item.
    Many thanks
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on September 30, 2015 at 08:29 AM

    Thank you for updating us. I'm sorry to hear that the CSV file did not work. Currently, I see that the ticket is already forwarded to our developer as a feature request, I'm unable to give an estimated date and time for this, but rest assure that we will update you directly on this thread when we hear any news.

    For the meantime, you could check the following links regarding report creation: http://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm

    You could also try using Google Spreadsheet integration, that will give you a better display of those check box items selected.

    Apologies for the inconvenience.

  • Profile Image
    JotForm Support

    Answered by jonathan on October 01, 2015 at 09:11 PM

    Hi,

    I was able to check on this further and discovered that the Checkboxes data result in Excel was actually delimited already by carriage return.

    I was able to check this on the result of your form http://www.jotformeu.com/form/52161858494363

    it is just not visible on the grid due to the way the Excel application was displaying the data. But for sure there is an existing delimiter that break each of the selected options/data of the Checkbox.

    Because of the delimiter, it will now be possible to re-create the data into separate column using the Excel function Text-to-Column 

     

    You will need to convert first the carriage return to another type (a comma sign is ideal) so that it can be simpler to do the Text-to-Column operation.

    You can follow this step to convert to comma the carriage return in your Excel application

    1. Convert the carriage returns to commas with  =SUBSTITUTE(A1,CHAR(10),",")

    2. Copy the result of above and paste special Value into another cell

    3. Use Text to Columns (Data tab, Data Tools group)

     

    Hope this help. Let us know if you need further assistance.

  • Profile Image

    Answered by ts9964 on October 08, 2015 at 09:45 AM
    Hi,
    Thank you for your answer. I have now been able to get the data to split into cells. Please could you advise how I get the same answer to go into the same column. Where the data is ordered differently from the form, this is placing the data into the same order of column. We need the same answers to go into the same columns?
    Many thanks for your help

    [cid:image001.png@01D101D5.4ABD3230]
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on October 08, 2015 at 12:48 PM

    It seems like the follow up concern you have is quite different from the original topic posted. To better assist you, I went ahead and opened a separate thread for it. Please refer to this link instead: http://www.jotform.com/answers/678810. We will address it accordingly.

    Thank you.