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.
Registering Multiple Children on one form?Asked by rbickings on April 27, 2015 at 10:15 AM
To all you smart people out there, I have a practical question for registering Vacation Bible School children at our church. I have already developed a registration form for the participants in our church's upcoming VBS program. It allows for registering multiple children (up to 6), while only having to pay one registration fee and have one parent/guardian. That all works well, so my question is, how do I get those children that have been registered on one form to appear on separation line's of a report? This will be necessary for our registration people to look down the list of names to see if the child is registered.
Hope this makes sense, thanks ahead of time, Pastor Dick Bickings
Unfortunately, it's not possible to separate them because from what I understand, they are group of fields separated by form collapse bar and page breaks. The fields will be separated by columns but they will still be in one submission.
What you can do is download the excel version of the submissions or integrate Google Spreadsheet into your form. From there, you can create another sheet inside the workbook and use the ImportRange function (this is in Google Spreadsheet) to import specific columns to another sheet and compile all the child registration there.
I hope this helps.
Yes thank you so much...I sort of thought that this might be the process I will need to follow, but thanks for confirming that...
Blessings, Pastor Dick Bickings
Just to follow up, you can use a Matrix Dynamique widget:
This will collect the data entered for each child as its own row of data, rather than separating it out into multiple entries as you have it now.
This would change the look of your form quite a bit and would require you to setup the widget similar to your current fields.
If you have any further questions, let us know and we will be happy to help.
I tried using the widget but when I download to excel all the kids names are still in one cell. How can I get them to split into their own line?
Unfortunately, my previous comment under this thread may have been incorrect. The matrix dynamique widget also collects data in a single cell as do all other widgets. The data would need to be split in the same manner described by my colleague.