Event registration with the option for multiple attendees

I am trying to build a form that allows for more than one attendee on a single registration. I have actually successfully built a form like this previously, but the problem is in the results when integrated with Google sheets. We would like for each of the additional attendees to have their own row in the spreadsheet rather than having the additional attendees becoming an additional column in the form. We sometimes register large families and with each attendee having to answer 8 or so questions, the number of columns quickly gets out of control. It would be better to have each additional attendee show up as a new row underneath the first attendee. Is there a way to do this? I tried Infinite list and configurable list, but that just puts all of their info and answers in one cell which isn't workable.

Hi loristevens,

Thanks for reaching out to Jotform Support. I'm sorry you are having difficulties with this. However, to understand better what you mean, it would be really helpful if you could share related screenshots of the issue on the form and on Google Sheets. As well as the URL of the form you are trying this in.

Once we hear back from you, we'll have a better idea of what's going on and how to help.

I think I found a work-around for this that solved my problem. I cut the registration into two parts, the main general info in one form and then upon submission they are redirected to the second form which is the individual attendee information that we need. Then at the bottom before they submit I used conditional logic to either send them to the attendee form again to register another person or to get just a normal "thank you" page if they don't need to register another person. This will make it so my integrated google sheets document will show each individual as a new row instead of adding 800 columns to the spreadsheet. Hope that makes sense.

Hi loristevens,

Thanks for getting back to us. Your workaround is great since you want to have every person their own row in the Google Sheets integration. We are glad that you are able to find a solution with your issue. If you ever face another issue with your form, do not hesitate to contact us.

Let us know if there's anything else we can help you with.