Need help to create a database

[Enrique_Fernand]

Hello, I’m trying to create a database for a virtual event, I want to create a base with a form, when people submit the form they would choose one slot, after sending the form I want that the reserved slot doesnt appear for the next people that submit a new form. Basically I want a template for reservations, but I dont know how to do it, the single select field doesn`t works for this because the same options appears for every form.

[Mohamed_Swella1]

Hi @Enrique_Fernandez_Wo,

Welcome to Airtable Community!

You can do it as a Linked Field and disable Allow Linking to multiple records. This will make you able to choose each record one time only.

BR,
Mo

[Enrique_Fernand]

@Mohamed_Swellam I tried but it don’t works, I`m trying with the League/Player Management Template. I disabled Allow Linking, but I can still choosing players.

[Mohamed_Swella1]

@Enrique_Fernandez_Wo you can do something, you can make it to choose from a specific view. This view can contain only the players that were not chosen.

The way to do so is to filter out the items that already contains a linked record.

BR,
Mo

[Enrique_Fernand]

I tried but dont works with the form

[Mohamed_Swella1]

If you want, send me a view link to your base and I will show you how to do it.

BR,
Mo