Feb 23, 2022 03:48 PM
I want to have people sign up for time slots. Can I have it remove each one for the next person? In other words, say the options are 1:00, 1:10, 1:20, 1:30, etc. When someone fills out the form and chooses 1:00, can I have it removed from the options for the next person so each time slot only gets one person?
Feb 23, 2022 04:19 PM
Yes, if you use a linked record field for people to choose available time slots from another table.
So your first table would be people, and your second table would be time slots.
In the time slots table, you would have to create all the time slots ahead of time as individual records, and then create a view which is filtered to only show you records that don’t yet have any people linked to them from your people table.
Then, use that filtered time slots view as the conditional criteria for the linked records field in the People table.
Feb 23, 2022 05:12 PM
Thanks! I read that 5 times and I’m still overwhelmed, haha! How do people “sign up?” I need to create a form view, right? So which one is the form? The people or the time slots? And that would mean anyone can choose a person and assign them a time slot? That could be troublesome. . .
Feb 23, 2022 06:01 PM
I don’t know enough about what you’re trying to accomplish, but if it’s the general public signing up, then you would want to create a form view. Ideally, the form would be created in the people table for the most simplicity, but it could be from any other table that you would link to time slots.
Feb 23, 2022 06:37 PM
Ok then let me tell you what I’m trying to do. It’s a music festival where students sign up and play their piece of music for a judge and get a rating and an award. Instead of just assigning everyone a time, (which creates problems because some people want specific times and there are hundreds of people), I thought it would be great if they signed themselves up for a time slot. But obviously there can only be one person per time slot with the judge. So ideally this is what I want to happen: they fill out the form where they enter their name (and other info) and then choose a time slot like 1:00 or 1:10 or 1:20, etc. But obviously once they choose it, it needs to go away from the options so someone else doesn’t choose the same time slot.
Feb 23, 2022 06:40 PM
Just follow my steps above.
Feb 23, 2022 06:42 PM
I tried, but I’m still confused. How do they enter their names if they’re choosing names from a table?
Feb 23, 2022 06:55 PM
I would probably just have them type in their names into a text field, because you can’t have them choose their names from a table unless you shake some things up. You would typically need to create a 3rd table — a junction table — that links to both of the other tables. This would require you to create a many-to-many relationship, which is explained in the support article below.
Alternatively, you could even stick with 2 tables and put all the names in a single select field. But that is really clunky, so I wouldn’t recommend that.
I would probably just have them type in their names into a text field. You could even do it all from a different table if you wanted to, and then after the form submission, you could either link the newly-submitted record to the original Students table, or automate the data to show up in the Students table.
Remember that each new form submission creates a new record, so you would want to design your base around that concept.
Feb 23, 2022 06:58 PM
Ok, but how do the time slots disappear once someone chooses one?
Feb 23, 2022 07:02 PM
As I mentioned above, you will need to limit the linked record selection to a view:
Feb 23, 2022 07:06 PM
But there won’t be a linked record if I’m having them manually type their name in. . .
Feb 23, 2022 07:19 PM
No, the name selection has nothing to do with limiting the time slots. Follow my initial instructions, and keep playing with Airtable, and you will get it.
You may also want to check out my free Airtable training course, which covers form creation & linked records:
Feb 23, 2022 07:22 PM
But you said
And then said I won’t have a people table. Just have them type them in.
Feb 23, 2022 07:28 PM
Sorry but I can’t donate any more time guiding you on this. It doesn’t sound like you’ve even tried building this yet. I would spend some time building it, and if you’re still stuck & you have a budget for your project, please feel free to contact me through my website:
Feb 23, 2022 09:10 PM
That’s a rude assumption. Yes, I’ve tried building it. I’ve messed around with it for many hours already and watched several videos and tutorials. Thanks for the insult and sorry you feel like you donated so much time. You didn’t have to respond if you didn’t want to help.