troubleshooting Question

Google forms for menu choices for large group evening meal

Avatar of Rob Henson
Rob HensonFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft 365SalesGoogle Workspace
2 Comments1 Solution110 ViewsLast Modified:
I am setting up a Google Forms questionnaire to collect menu choices for a group evening meal. We are expecting 100 to 120 guests so menu choices have to be pre-selected.

I currently have it setup that you have to submit a separate form for each person attending the meal and am using a party organiser name to group the results together.

As it will be mostly families that are completing the form it would be great if one person could complete the form with a list of names and then each individual's menu choices. I would expect each family group to be less than 10 but wouldn't want to apply a restriction just in case.

There would be some basic questions, party organiser name, email etc and then would be great if it could flow as:
Guest 1, add menu choices
Add another Guest or Submit
Guest 2, add menu choices
Add another Guest or submit
etc etc

I have looked at the various templates and I notice in Google forms there are various Add-Ons that can be enabled but haven't found one that does this. Does anyone know of one that does?

Current setup generates a spreadsheet with a list of the choices which I can easily summarise for submitting to the venue.

I could set it up with pre-determined number of guests but I don't believe that would generate the summary sheet like I currently have and I have to make a decision on how many guests per submission, too few and the person completing still has to complete multiple submissions, too many and the person completing has blank question sections to scroll past and I end up with multiple blanks in the summary sheet.

The summary facility needs to stay but it doesn't have to be Google forms, only using that because I have used it before and understand it; and its free, which is also required as it is for a volunteer group. I have a personal O365 subscription which includes MS Forms but that does not seem as extensive as Google forms.

What would also be great but maybe stretching a bit here, if each Guest added could be included in a total cost which is then delivered to person completing the form so they know how much they will have to pay for the evening; there will be a category choice for each guest (member or guest, adult or child etc) with different prices.

I realise this is effectively an online sales/order form so would expect there to be something out there to enable this but it has to be free and has to be simple to setup and subsequently use. I am doing in this in my own time as a volunteer. As a group we have previously done this the old fashioned method on paper but if it works this time there may be scope to use it again so might be able look at using a paid version but it would have to be very cheap.

Any help greatly appreciated,
ASKER CERTIFIED SOLUTION
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros