You can find an example here… Or Does anyone know how I can “attach” an example?
Hmm, if you’re just counting linked items, you could do this via adding a Count field in the Inventory table
I’ve added it in the example table you linked
Thank you @Adam_TheTimeSavingCo , Perhaps I didn’t explain myself clearly. What I’m trying to get to is to know what the stock qty out of the inventory is for each product based on the sales orders. The sales orders are placed by packs and the packs and product relationship is many to many. Does that make sense?
I feels more like an Airtable limitation but I wanted to check if anyone has come across with a requirement like this.
1- Granular data that holds Inventory items (SKUs)
2- Packs (or combos if you like) made out of one or more inventory items
3- Sales orders made out of packs and therefore ivnetory items
How can I know how many items have gone out (due to a sale) from the inventory?
Thank you @Adam_TheTimeSavingCo , Perhaps I didn’t explain myself clearly. What I’m trying to get to is to know what the stock qty out of the inventory is for each product based on the sales orders. The sales orders are placed by packs and the packs and product relationship is many to many. Does that make sense?
I feels more like an Airtable limitation but I wanted to check if anyone has come across with a requirement like this.
1- Granular data that holds Inventory items (SKUs)
2- Packs (or combos if you like) made out of one or more inventory items
3- Sales orders made out of packs and therefore ivnetory items
How can I know how many items have gone out (due to a sale) from the inventory?
Ah okay. For that, you’d put the count field in the Packs table and pull the sum over to the Inventory table via a rollup field with the formula SUM(values). I’ve done that in your base and you should be able to see it there
Thank you so much @Adam_TheTimeSavingCo , that was simple enough 
