How to Limit Dropdown Choices Based on Another Field in Airtable

Imagine your organization is tracking office locations across the world, and each record needs both a country and a city.

But when you select a country, you still have to sift through a long list of cities—including ones that don’t belong to that country. It’s easy to pick the wrong city by mistake, leading to inconsistent data.

Wouldn’t it be much easier if, as soon as you selected a country, only the relevant cities appeared? This simple fix can be achieved using dynamic filtering in Airtable. Here’s how to set it up:

Step 1: Create a "Countries" Table

Start by building a table that lists all the countries where your offices are located. Each record in this table represents a country—like India, France, or Canada.

Step 2: Create a "Cities" Table

Next, create a separate table for cities. Each city should be linked to its corresponding country. For example, Paris would be linked to France, while Toronto would be linked to Canada.

Step 3: Build Your "Locations" Table

Now, create your main table where office details will be stored. This table should include the office name, a Country field that links to the "Countries" table, and a City field that links to the "Cities" table.

Step 4: Enable Dynamic Filtering

To ensure the City field only shows cities that match the selected country, follow these steps:

• In the City field settings, enable Filter record selection by a condition.

• Click Add condition.

• Then go to Settings > Dynamic conditions.

• Choose the field you want to filter by—here, select Country. Set the filter to "has any of" and select the Country field from your table.

Airtable will now automatically display only the cities linked to the selected country.

And that’s it! Now, whenever someone selects a country, they’ll only see relevant cities—saving time, reducing errors, and keeping your data clean.