Jan 12, 2017 01:51 PM
Well, I’m new to Airtable and have been stuck in this dillema:
I created a table called Recipes (where I log ingredients and other info), and another one called Ingredients (Where I keep average prices, and quantity on stock), so I can keep up with my groceries.
I want to calculate how much will I spend for each recipe, so I can calculate the average dish price.
Is there a way that I can put a value for each ingredient in the recipe (like, 1kg of meat, and 0,3kg of onions ), so I keep my inventory updated?
Below it’s some screenshots of what I’ve got so far…
Thx!
Jan 12, 2017 02:17 PM
To log the quantity of ingredients, you’ll need to make a separate table for recipe line items. Here’s a tutorial on implementing line items (which also contains an explanation of why you need to ... The example in that tutorial is related to the product catalog example, but I’ve also built a sample recipe base myself which uses the same concepts:
Ingredients table, with cost per cooking unit.
Line items table, which is basically ingredient x quantity per each record
Recipes table, which uses a rollup field to sum up the total cost of all the line items.
Let me know if you need more assistance.
Jan 13, 2017 06:40 AM
Thank You Kat! That’s exactly what I was looking for!
Aug 11, 2017 12:15 PM
Hi Kat, any chance you’d be willing to share that doc as a template?
Aug 11, 2017 12:21 PM
Jan 16, 2018 06:17 PM
Is there a template for recipes/ cookbooks?
I’d really appreciate not having to invent one as this is not my strength.
Thanks!
Nov 04, 2022 05:42 AM
This is great thank you for sharing. I have a question, in the cooking unit cost field how is this being calculated?
Jan 26, 2024 10:58 PM
Hi @Tom_Tiernan were you able to find the recipe/cookbook template and willing to share?