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.
How can I create a registration form for multiple (variable) attendees?Asked by capbl on January 04, 2014 at 09:53 PM
We are trying to create a registration form for a conference. Registrations will be submitted by chapters, not by individual members, and payment will be made by the chapter for the full delegation.
Each chapter will have multiple attendees, and the number will vary for each chapter. For instance, chapter 1 may bring 5 people to the conference, while chapter 2 brings 15.
Additionally, we need to collect data on each attendee, e.g. which option are the choosing for session 1, which for session 2, etc.
Ideally, there would be a series of questions associated with the chapter, e.g. who is the president, who gets the Grand Umba award, etc. Then, they would tell us how many people are coming under each of mulitple pricing options (Price 1, Price 2, etc.). Then, for each individual, they would fill in the options specific to that person.
When we download the file into Excel, we would need to be able to see the data for each individual attendee on a separate row.
It seems you've already used the right tool to collect user information on your form. If you don't any clue how many number of users per chapter, dynamic fields would be the best tool that may fit on your requirements. They can easily add more fields dynamically on the form as they pleased. Here are some dynamic fields that you may want to try.
You can also apply hide/show conditions on your form if you'd like to hide/show fields depending on the chapters selected.
Regarding on the Excel data, each field questions are arranged by column depending on your form structure. Unfortunately, you can't arranged or organized the columns on the submissions page, you can only do that when you download your submissions data to excel file and edit it on your excel program.
Please let us know if I've missed something or if there's anything else you need help with.
I have used this widget:
I have a field which shows the number of attendees and I want it to automatically update depending on the number of rows in the Matrix Dynamique field. I used the conditional fields option to calculate the value but it didn't work.
We will answer your question here https://www.jotform.com/answers/930654. We'll be on it shortly.