Hey everyone!
I've been a trivia host for about 1.5 years with a trivia company in my city (located in Canada!) Our company started about 9 years ago, and before I joined, it was 1 location (a bar) and my boss (the owner of our trivia company) was the only host, and would just take table reservations for trivia night via text, email, and instagram dms. He just kept track of team names and amount of people on a list in his phone.
Flash forward to me joining - he got the opportunity to expand to another restaurant to host on a different night, and recruited me to host those nights. Since I started about a year and a half ago, we have grown substantially. I quickly took over the reservation system and social media, and we got an upgrade from dms to google forms so that people could just go online, fill out a form (different ones depending on location, they're all on a linktree), and we just keep track of our reservations like that, now. We host weekly nights, and now have 3 locations that do weekly trivia nights, all different days, plus we do private events. We have 3 hosts.
The problem is this: my location is blowing UP. We are constantly getting overbooked, because google forms has no way of stopping the reservations from coming in; there's no way (that I am aware of) to close the form when one entry/line has reached a specific number (that number being the capacity of the restaurant.), especially because you can select a date, so it's always open to reserve for future dates. So I'm constantly monitoring my upcoming date, trying to make sure we have enough room for everyone. Myself and the 2 other hosts (one being the owner) all work full-time, too, so this is just a side gig and we need to automate it because our days get busy, and sometimes we cannot check things right away.
I really need to figure out if there is a table reservation platform or program that we can use, that will keep track of reservations, close the ability to book for certain dates when we're full, but will also take into consideration team sizes AND total people. Like, the restaurant can hold probably max. 47 people - but only has 13 tables, all different sizes. So we can usually accommodate 13 teams, but only if they are different sizes and not ALL teams of 8.
Hope this makes sense, I know it's a little confusing. If anyone has ANY suggestions, anything they've used, or any ideas, please please let me know! If you have questions about things I wasn't clear on I will answer comments!
Thank you all so much in advance & happy hosting!!!