Automate slot creations

Yeap that sounds right!  You could either use an automation or a record template for this and I’ve created both here for you to check out:

https://support.airtable.com/docs/using-record-templates-in-airtable

Personally I’d prefer using a Record Template as they feel easier to maintain than a bunch of Create Record steps, but there’s really not much difference

And here’s how the automations look:

---

May I know how you plan on letting people sign up?  In my head you’re probably going to give people access to a page where they can see all the available slots and sign up and so I set up something in the base to handle that as well:

The idea is to create a prefilled form link so that people can click the ‘Sign up’ button for each slot and just put in their name, and the shared view has a filter to filter out any slots that a person has already signed up for

https://support.airtable.com/docs/prefilling-a-form-via-encoded-url

There’s an edge case where two people click on ‘Sign up’ at the same time and end up signing up for the same slot I’m afraid.  In that situation I’d suggest having an automation that’ll email the later volunteer that their slot has been taken. 

Services like Fillout allow you to prevent double sign ups but iirc they need the Enterprise plan for that which seems like overkill here