Help

Re: How to remove an option to the menu on the Form

711 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jufacundes
4 - Data Explorer
4 - Data Explorer

Hi guys,

I'm creating a escape room form, so the group can select the room and time they want to play.
There are 3 rooms (each one with 5 different times to play).

When a group select the room/time (example: Room 1 - 20h) this room can't appear on the form anymore.
How can I do that?

I read in other message here to create a new table with all the possibilities (I already did that), and created a link to another record in the main table (which is used to create the form).
I tested it but it didn't work.

If anyone could help me, I appreciate it! Thanks

4 Replies 4

I give a demonstration on how to do this on this Airtable podcast episode.

Hope this helps!

- ScottWorld, Expert Airtable Consultant

Hmm, try setting up a view that only shows available time slots like so:

Screenshot 2024-10-04 at 9.28.45 AM.png

Then, in your form table, limit the record selection to that view:

Screenshot 2024-10-04 at 9.28.37 AM.png

After you've done that it'll only show records that aren't linked to any existing submissions:

Screenshot 2024-10-04 at 9.28.34 AM.png
And this is my data:
Screenshot 2024-10-04 at 9.27.34 AM.png

Link to base

If you've got a teams plan you can just use the "Filter record selection by condition" option too!

 

 

THANK YOU!!!

I did it!!

You're welcome! Glad I could help! 🙂