Help

How to have selection only show linked items?

1157 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Purple
4 - Data Explorer
4 - Data Explorer

I am trying to create a selection that only shows relevant items. For example, say we have 3 stores (Target, Walmart, and Costco) that sell different brands of items (Brand A, Brand B, and Brand C). Target only sells Brand A and B. If I enter “Target” as the store in my table, is there a way for another column to let me choose one of the two brands Target offers (i.e.- choose from Brand A or Brand B only)?

I’ve seen the Lookup field type, but this displays Brand A and Brand B, whereas I want the user to be able to choose one of the Lookup options. Is this possible?

This is just a test scenario I am trying to get working to see if Airtable is capable of doing what we need before getting more complex.

Thanks in advance for any help you can provide!

1 Reply 1