JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Is there a way to get a individual items(camps) listed on an excel form?Asked by 4Hregion1 on February 25, 2016 at 04:22 PM
Last year we had individuals sign up for each camp on a seperate submission. We were then able to have each camp listed individually on our excel form. These individuals then indicated they did not like the inconvenience of doing multiple submissions. This year we decided to list all camps on one submission form to make it more convenient for them. But now we are finding the camps are not listed individually on the excel spreadsheet, they all run together in the cell.
Is there a way to have individuals still select camps on one form but have them individually listed on the excel spreadsheet so we can sort and find how many kids are signed up for what camp?
Thanks for your help,
Unfortunately, there is not option to separate the answers in your form, this is because all are answers of a same question, this is the reason why they are being saved on the same field.
If you would like to have each selected option in different cells in your spreadsheet, you will need to add each answer as a field, so for example, if for one question you have 10 answers, then you will need to split it in 10, so you will receive one selection in different cells.