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.
Google Spreadsheet: How do I get data from widgets on separated columns?Asked by SUHPL on March 07, 2017 at 01:35 PM
We want to design a form that would create multiple submissions from one form. This form will be used by coaches in the field to evaluate a team of athletes. For efficiency, I want the coach to be able to evaluate all of his athletes on one form, but when he submits the form each athlete would have their own submission (We want each athlete to have their own row of data when exporting to excel/csv). This data would get pulled into a data analytics platform that would allow us to visualize each athletes scoring based on the coaches responses in the field.
The linked form (https://form.jotform.com/70606928366969) is as close as we could get to an optimal design, but the corresponding submission/export is not usable for our purposes. It doesn't list all athletes per response, and athletes are grouped into one cell per question (see screenshot). We want a column per question, and a row per athlete, with the responses (does meet or doesn't meet) in the cell. Generated from a form that generally looks like the one we have. Is there a way to change how responses are stored in the system to meet our needs? If not, do you have any recommendations for how to achieve a form with these qualities?
I have reviewed your form and I can see you're using the Visual Multiselect widget to list your options, do note that due to the widgets nature you will get the info in that way, for example, each selected value will be separated by commas (,).
If you would require to have the records separated as a single field (since each column is a field) you need to use a basic field or use separated widgets to capture each data, this way you could data the data separated as well in your spreadsheet.
If you have any question, let us know.