Hey all, I've recently created an AppSheet to track inventory levels for various equipment I distribute to users at my site. The Appsheet has been very useful, and now my colleagues at other sites are asking for their own copy of my app.
Rather than simply cloning my app, I was hoping to incorporate different locations to track the inventory levels across each set.
Ideally, launching the app would show you the total count of each item, and selecting a specific item would break down the totals at each site, which can be added to or reduced.
I know this is possible but having a hard time figuring out how.
My AppSheet currently consists of two tables:
Items- Fields: Item ID, Name, Category, Image, Amazon purchase link
Inventory- Inventory ID, Item ID, DateTime, Amount
I'm thinking I would need to add a new table for location, but not sure how to correlate that info to the current inventory.
Any assistance would be much appreciated!
So the simple way would be to:
Not a 100% sure exactly how you Item and Inventory tables work together. Presuming that Inventory is the daughter table of Items
Simon@1minManager.com
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |