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.
Have you made improvements to the way the form information downloads into Excel?Asked by GraceAlumni1TD on July 14, 2015 at 03:49 PM
I am new to my position and working with Jotform, but I am aware that last year, the information that downloaded into Excel placed ALL events for which one person was registered into one cell. Therefore, it was impossible to sort for the registrations of each event. Each event then had to be cut-and-pasted into separate cells, creating hours of unnecessary work.
Has this issue been resolved to that separate events for which a person registers are populated into separate cells?
It depends on how you collect the data. If you are collecting all the information for the events the person registered for in a single field, then yes, the data will be in a single cell in the spreadsheet. If you are using a configurable list widget or a matrix of some sort that collects a large amount of data in a single field, this data will be reported as a single entry.
If you are collecting the data using multiple fields, for example using a separate field to collect their name and another to collect their address, the data collected in those fields would be entered into separate cells in the spreadsheet.
It all comes down to if you are using a single field that allows multiple data entries or multiple fields that allow for a single entry each.
We are still having challenges and questions regarding using multiple events for our Homecoming registration. A number of the events require payment. If each event is a separate (Payment Wizard?), how will it calculate a grand total.
Do you have a tutorial that can show this?
To have everything separated out, you would use regular fields and calculations values:
You would then total up those calculations in a calculation widget:
After you have your total calculation set up, you can pass the total to your payment field:
This would allow you to break your selections up into separate fields, then send the grand total to your payment field. If the forum slows down, I'll setup a test form with some of the selections setup.