
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 28, 2020 09:13 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 28, 2020 04:17 PM
Hello! Would you mind re-sharing your base? It isn’t appearing well for me

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 28, 2020 07:46 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 29, 2020 03:03 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 01, 2020 12:49 AM
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.
