Different amounts in different recipes

[Doterra_Kaisu]

Hi!
I’d like to build a simple recipe database. I have different ingredients which are parts in different recipes but the various quantities are the problem. I saw an article about this in here but being a total beginner couldn’t quite understand what it meant.

So I have a table for ingredients and a table for recipes but how I set the quantities. Like:

Recipe #1
2 lemon
2 peppermint
2 lavender

Recipe #2
1 lemon
5 lavender
4 spearmint

So when I am saving my recipe I would like to choose the quantity for each ingredient and the quantity of course is a different one according to the recipe I’m saving to my database.

[nea_lpatil]

@Doterra_Kaisu

Check out meal-planner with good combination of recipes and ingredients by @Kamille_Parks
You will get many ideas for recipes.

Airtable

Ultimate Meal Planner - Airtable Universe

This meal planner base has it all! Shopping list generator, recipe page builder, support for "sub-recipes", you name it. Mix-and-match entrees and side...

Neal

[Kamille_Parks]

Thanks for the shoutout, @nea_lpatil.

What you would need to do is make a third table to pair ingredients with a quantity, and associate it to a recipe. The base I made (linked above) does this using a table called [Recipe Ingredients]. Feel free to make a copy of that base to use for yourself! I can explain it’s mechanics further if need be.

[Doterra_Kaisu]

Thank you so much ladies. :blush: :heartpulse: I will follow your advice.

[Doterra_Kaisu]

I’m sorry (and feeling very stupid indeed) but when adding new recipes where do I change the quantity so that it’s different in each recipe. Say I want to use 3 tbsb lemon juice in other recipe and 5 tbsp in the other.

[Elias_Gomez_Sai]

You enter that in the new table. Every record is like a line in the Ingredients section of a traditional recipe in paper. And you have to link those lines with its recipe.

[Kamille_Parks]

If you’re using my example, you would input the quantities of each ingredient in the [Recipe Ingredients] table, which would look something like this:

Notice how each ingredient quantity gets its own “line”, and each one is linked to a recipe.

[Davide_Tortelli]

Greetings!
This question has been very useful to me, so thank you all!
In fact, I am currently using @Kamille_Parks base to create a cocktail-recipe book.
A new issue occurred to me while working on my base and thought that I could share it here instead of starting a new thread because chances are it could be useful to anyone reading this.
The thing is: in some cases, I would want to put not just an exact amount of a certain ingredient but I would rather put an interval of amounts, for example: 2 to 3 dashes of Angostura.
Any suggestions?
Thanks in advance, I really hope I’m not off-topic

[Kamille_Parks]

I’ve kind of done this with the “to taste” option in the {Qualifier} field, which I use when there isn’t an exact amount of an ingredient used. You could also add “dash” to the {Unit} field

[Sasha_Chernysho]

@Kamille_Parks this database solved many issues I had when creating a similar version. The only thing that I can not view is the original scripts used for leftovers and prepare. (I am on pro version, they just didn’t copy over). Can you, or anyone who got them to work, paste them in this thread so they too can be recreated. Please and thank you!