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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.