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…