Hi @Gregoire_de_Montety,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

You will need to do all this work just one time and everything will fall into place after that.

You need to step a tables for the recipes, ingredients of recipes, prices of ingredients, etc.

The part where you say that an opened bottle is sold, this can be done in so many ways depending on how it is used. Meaning you will use 9+ bottles in an event so you will charge them 10? Cause then you can use the Ceiling formula and it will give you the highest integer. Or is it more complicated that that?

BR,
Mo

Hi Mohamed, thanks for your quick answer !

Here is my draft : https://airtable.com/shroO8vmINRhBnCvB

I get somewhere yesterday with a roundup formula - wich is quite similar to your formula I think (same nb of value).

I overcome by manualy link the order with all the ingredients in the Order_line table.

As for each pack, it’s always the same recipe, I don’t want to link every ingredient to the order as if it they were always different. In other words, it’s not (yet) about automate my work from a unique order to unique items, it’s about gather info so when someone order a pack, it always means recipe X and recipe Y wich mean ingrédient A,B,C,D,etc. and to link the number of attendees to the quantity /cocktails and the quantity /btl.

Do you have any trail ?

That looks really impressive ! I think you got it working already

But no matter which pack the customer chose, I have to select manually all the ingredients - I can even pick ingredient which are not in the pack or pick some twice. Do you think it’s possible to link pack, ad hoc recipes and ad hoc ingrédients together so when someone make an order I just need to link is order line with the pack in an order line table ?

I think you cannot do that because of the bottle thing. You need to check every time how many bottles you need.

Indeed, this is what I was afraid of :confused: Do you think I can fix it with Zapier ?