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…
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.