- ts9964Asked 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
- JotForm SupportjonathanAnswered 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.
- ts9964Answered on September 24, 2015 at 03:34 AM
The form is within my managers log in, I believe. The location is:
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
- CharlieAnswered on September 24, 2015 at 11:21 AM
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.
- ts9964Answered on September 24, 2015 at 01:47 PMThank you I will check the CSV option tonight.
Tracy Small (ts9964)
- ts9964Answered on September 30, 2015 at 04:47 AMThanks 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.
- CharlieAnswered 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.
- JotForm SupportjonathanAnswered on October 01, 2015 at 09:11 PM
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.
- ts9964Answered on October 08, 2015 at 09:45 AMHi,
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
- CharlieAnswered 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.