Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: If This Then That type selections in base

318 0
cancel
Showing results for 
Search instead for 
Did you mean: 
charliekarve
4 - Data Explorer
4 - Data Explorer

Hi there, is it possible to have a column only show certain single select fields dependent on what the previous column select e.g. I want to only show items within a certain category not all the items in all the categorys.

Column A = Categories
Column B = Subcategories

I only want to show the subcategories within the category I select.

TIA

Charlie

2 Replies 2
Saravanan_009
8 - Airtable Astronomer
8 - Airtable Astronomer

You can set up your Airtable to only show subcategories based on the selected category by linking tables. When you select a category in Column A, Column B will automatically show only the relevant subcategories for that category.

I'm afraid that's not possible with single select fields.  If you're open to changing your base structure by replacing those single select fields with linked fields to new tables, you can use Airtable's dynamic filtering functionality which will do what you need: https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields