First off, link: https://coda.io/d/FC-Asset-Tracking_d_4LZMlCxvR/_surD4
Essentially I have an inventory system. I have one table with supply chain receiving. This means I receive multiple of the same items (ie; multiple shipments of the same type of batteries)
The second table is my ‘Total Inventory’. This displays the on-hand quantity of an item (how many batteries I have, given all the shipments I have received)
Essentially it is a sum of all my shipments, filtered by a certain item type. I just can’t get the filter to properly work. Trying to make this a button but if you have a different method, please let me know!!
Let me know if I can clarify anything! Eventually I’ll want to subtract shipments from total inventory, given the product shipped, but that is a separate and likely more advanced topic. Also my products have multiple items, and I want to serialize some of them. This is more complex than a simple e-commerce store with 1 or 2 one item products.