Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Track Room Items

Topic Labels: Base design
2096 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Timm218
6 - Interface Innovator
6 - Interface Innovator

I want to track what items are in which room. What is the ideal solution for this? For now, I am not interested in the quantity, but only that a certain item exists in a room or not. For the items exist unique categories, namely furniture, tool and machine.

This is what I have created so far, two tables ‘Room’ and ‘Interior’:

Currently, I do not have a junction table. I created three columns in the ‘Room’ table based on the unique categories and linked it to the ‘Interior’ table. I restricted the link per view (depending on category).

Is this the best possible way to present the information I want? Or do I need a junction table and if yes how do I implement it?

4 Replies 4
andywingrave
10 - Mercury
10 - Mercury

Hello! Would you mind re-sharing your base? It isn’t appearing well for me

Timm218
6 - Interface Innovator
6 - Interface Innovator

It is not appearing well for me too. This seems like a bug? I just copied the link.

Here is the pure link:
https://airtable.com/shr48RVM9qqv9q2a3

Hi @Timm218,

I think this is a good setup, as long as it gives you the data that you need.

BR,
Mo

Timm218
6 - Interface Innovator
6 - Interface Innovator

One issue I have is that it seems not to be possible to automatically order the linked items alphabetically in the ‘Room’ table? This is problematic when I want to check if I have already added a certain item to a specific room.