Awesoooome, thank you so much guys!! My actual situation is soo much more complex, I’ve got keep inventory and purchase 200 items for 7 locations, so I went with the entity table and it makes it possible :grinning_face_with_big_eyes:
Thanks for the quick response!
Ok, I think I understand. It’s would be long because there isn’t a repeated formula “type” per product type.
All 200 products have individual formulas, more or less.
So I’d have to input all 200 products and 200 formula...
Hi @bdelanghe! I’m trying to do the same thing, it’s too bad he never answered your reply!
I’ve got a long list of products and the estimate we’ll need to buy varies per product - for example:
we need 5 t-shirts per employee = Employees * 5we need bo...