Skip to main content

Requires Linked SingleSelect/MultiSelect Dropdown, which can be restricted on the basis of any criteria. In particular I need Dropdowns, which offer a subset of choices based on the result of another dropdown/field.

For example, I would like to have a drop-down “LAND”, which gets the data from a separate table (LAND, REGION).

The table would then look like this:
COUNTRY, REGION
Switzerland, Aarau
Switzerland, Bern
Switzerland, Zurich
Germany, Baden-Württemberg
Germany, Lower Saxony
Germany, Saarland
France, Aquitaine
France, Brittany
France, Poitou-Charentes
…, …

A second dropdown “REGION” should then only show the regions matching the selected country.
Then the second dropdown should only show “Aquitaine”, “Bretage” and “Poitou-Charentes” when I select “France” as the LAND.

If I look up in the forums, this is probably a very popular wish for a long time. Is something like this available now and if so, how does it work?

Hi @Patrick_Blattner

Welcome to the Airtable Community! Thanks for sharing your request for conditional single select and multiple select fields.

Unfortunately, we don’t currently support conditional select options in a field. This is something we’re considering eventually supporting, but I don’t currently have a timeline for doing so.

I’d love to pass this feedback along to my team as a way we could improve the product further – thanks for surfacing it! Also, you can stay on top of Airtable product changes from our What’s New Page.


2025 Update:

You can now successfully do this by using Airtable’s dynamic filtering feature and matching the same field types between 2 tables.

If you’re trying to add this feature to a form, note that this requires you to set this filtering feature at the FIELD LEVEL (i.e. for your entire base), instead of just setting it at the FORM LEVEL (i.e. just for your specific form).

It is often easier & better to do this with Fillout’s advanced forms for Airtable.

With Fillout, you can leave all your fields alone in Airtable, and just setup a form that has this dynamic filtering feature.

Fillout is 100% free, and it lets you update existing Airtable records with a form or create new records in Airtable.

You can use Fillout’s dynamic filtering features to filter your linked record fields to only show the user the linked records that you want them to see, based upon other data.

Fillout also offers hundreds of other features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a formadd a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld