Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 25, 2019 10:19 AM
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.
Aug 25, 2019 06:12 PM
Check out meal-planner with good combination of recipes and ingredients by @Kamille_Parks
You will get many ideas for recipes.
Neal
Aug 26, 2019 12:22 AM
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.
Aug 30, 2019 08:31 AM
Thank you so much ladies. :blush: :heartpulse: I will follow your advice.
Aug 30, 2019 09:01 AM
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.
Aug 30, 2019 09:05 AM
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.
Aug 30, 2019 09:17 AM
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.
Feb 28, 2020 10:50 AM
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
Feb 28, 2020 12:23 PM
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
Sep 01, 2020 01:59 PM
@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!