Skip to main content

Hi know that creating a recipe with several ingredients and do the calculations 

So I was thinking to do the recipe vertically 

Is that working for me ?

 

Please advise 

 

Regards 

Need some more details on what calculations you mean to advise specifically, but generally what you should do is create a base with two tables, one called Recipes and another called Ingredients. Then create a linked record field between them, allowing you to link multiple ingredients to each recipe. 


Hey ​@Chef Tarik.

Your database will probably want to look smth like this:

Table: Ingredients
Fields:
Name (single line text)
Recipes (linked to Recipes)
Unit of Measurement (single select)


Table: Plates
Fields:
Name (single line text)
Recipes (linked to Recipes)


Table: Recipes
Fields:
Ingredient (linked to Ingredients)
Quantity (number)
Unit of Measurement (lookup from Ingredient)

By tracking costs at an Ingredients level (additional fields) you will be able to use such values for calculations at a Recipes level, and at a Plates level. To such effect, you will be leveraging rollups. You can read more about rollups here.

Please do let me know if you have additional questions, or feel free to schedule a call!

Mike, Consultant @ Automatic Nation