Dynamic records (for the lack of a better term)

Topic Labels: Base design
1133 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi Airtablelers!

I’m struggling with a logic problem here and would really appreciate some insights.

I have a Spaces table that lists the shelf spaces I have in a store.
Each space is defined by its column number and a letter specifying its row. Each column is different so not every column has every letter.

Screenshot 2020-11-10 at 13.45.02

Then I have a Brands table where I need to assigns these shelf spaces to different brands.

For the brands table I want to create a Linked Record or Dropdown that lists every space available. basically listing all the combinations from my Spaces table.

In this example the list would be like:


Is this achievable at all? What’s the best way to achieve this?

Thank you so much!

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Isn’t this possible at all?
What would be the closest I can get?