- rbickingsAsked 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
- CharlieAnswered on April 27, 2015 at 12:14 PM
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.
- rbickingsAnswered on April 27, 2015 at 12:23 PM
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
- JotForm SupportdavidAnswered on April 27, 2015 at 01:30 PM
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.
- EducationInActionAnswered on August 26, 2016 at 04:14 PM
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?
- JotForm SupportdavidAnswered on August 26, 2016 at 04:32 PM
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.