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

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

ts9964

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

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

Charlie

Answered 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:

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.

ts9964

Answered on September 24, 2015 at 01:47 PM

Thank you I will check the CSV option tonight.Many thanksTracy Small (ts9964)...

ts9964

Answered 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...

Charlie

Answered 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.

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.

ts9964

Answered 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]...

Charlie

Answered 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.