Click on a cell to open a sub-table

Topic Labels: Base design
1275 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello, I am new to Airtable with one base created (and one table in this base). I have a list of states in a column. Ideally now I want to create a separate table for every individual state with its cities listed. I don’t know how to create a link / jump action from the main table by clicking a state name resulting in the individual state’s table opening. I tried to create an adjacent column in the main chart with a button (in case it were not possible to make a state name itself clickable) but am not having much luck. Thank you to anyone with advice…! :slightly_smiling_face:

1 Reply 1

Welcome to the community, @CK12!

You can convert that column to a linked record field (which will give you the opportunity to create a table called States), and then you can click on the state name to view an expanded record of that state from the states table.

To learn more about linked record fields, you may want to check out my free Airtable training course, where you will become an Airtable expert in 90 minutes! :slightly_smiling_face: