Hi
I am building an inventory control app on glide, the main objective is to control inventory items of the different appartments each time it changes tennant.
So the idea is to have a homepage with the APPARTMENTS, and once I enter to certain appartment I can see the list of items on that appartment and check if something’s missing. If there is, I input that I have 10 forks instead of 11 and a nice RESTOCK alert stores on that table.
All that, I accomplished for 1 appartment… I am having lots of trouble trying to build the right table architecture for making it dynamic with other appartments.
So the ideal thing would be to have a master ITEMS table where I list all the possible items I can find on an apparment. But not every appartment will have all of this items and not the same quantities
So next what I would love to accomplish, is create the APPARTMENT 1 THINGS table that brings all the items on the master ITEMS table but I can continue and add columns as BOOLEAN to put it ON/OFF if the item is in that appartment and the QUANTITY of that particular item
So, in the future, if I edit the ITEM name from the master table, all the appartments will be updated, but at the same time I can have different items in APT 1 than APT 2 as well as quantities
Is there a way to accomplish something similar to this?
Thanks
AA