I have products each product can have parts (name + quantity) or can be a bundle of parts (name + quantity).
I would like to create a production planning for a week.
I would like to create a view of all row material I need for the production of the current week.
For example Product 1,2,3 are simple product, Product 4 is a bundle product consists of products 2(qty 1),products 3(qty 2).
In the current week I need to create 10 products of Product 1 and 10 of product 4.
The report should show me:product 1 10, product 2: 10 and product 3: 20
Is it possible to implement it in Airtable?