How do I filter a list of options based on a prior selection

[Gerald_Griffith]

I have a table where I want someone to select which ‘venue’ a session takes place in. They also need to select a ‘location/room’ in which the session takes place.

How would I set this up so that if someone selects ‘venue 1’ they only see a list of room options in ‘venue 1’ when they go to fill in the field for ‘location’?

[Brilliant_Admin]

This would be super helpful. We have several such list which, at this point, require our users to ensure they manually select appropriate options based on prior data they’ve selected.

Perhaps a way to pass parameters to a view from other selected columns.

[Justin_Barrett]

Check this Show and Tell post for details on building such a setup:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…

[Btbml]

That Show and Tell was probably the single most useful thing I’ve found on airtable since starting to use it. Its been foundational in a couple bases.