Jan 18, 202308:48 AM - edited Jan 18, 202308:50 AM
Hello Airtable Community,
I'm creating a form where I need a specific number of volunteers for each area of an event I'm planning, for example, I need 5 volunteers on Saturday from 9am-12pm; 5 volunteers on Saturday from 12pm-3pm, etc.
What can I do in creating the form to where as the volunteers sign up for various slots, the available number of slots decreases from 5 available to 4 to 3 to 2 to 1 to 0?
I don't want six volunteers to sign up, I don't want the sixth person to see it would be an option. Any suggestions would be most appreciated!
As much as I love Airtable for everything, take a look at signup.com if you haven't already. It's designed to do specifically this.
Also, because I enjoy figuring stuff out, I built a base in Airtable using Roll-up fields to count the number of people who have signed up and only display events that are less than capacity for additional sign-ups. It's a two-step process as I've put it together (I hate having people put their names in repeatedly for future forms, no data on what they've done), but you could just replace that entire section with a generic "what's your name" on the form.