Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Dynamic records (for the lack of a better term)

Topic Labels: Base design
337 1
Showing results for 
Search instead for 
Did you mean: 

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

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