Sep 22, 2020 03:41 PM
Hello! I have a base with ingredients, recipes, and meals. I’ve seen similar bases but none that ask this specific question.
Meals reference recipes, and recipes reference ingredients. The meals table has a lookup to list all ingredients for the given meal based on the listed recipes for that meal.
How do I get the number of times each ingredient has been used based on the meals table?
Solved! Go to Solution.
Sep 23, 2020 03:12 PM
Welcome to the Airtable community!
Try using a series of rollup fields. In the [Recipes] table, have a rollup with the COUNTA(values)
aggregation formula that counts the number of meals. Then, in the [Ingredients] table, have a rollup with the SUM(values)
aggregation formula that adds up the numbers from the [Recipes] table.
Sep 23, 2020 03:12 PM
Welcome to the Airtable community!
Try using a series of rollup fields. In the [Recipes] table, have a rollup with the COUNTA(values)
aggregation formula that counts the number of meals. Then, in the [Ingredients] table, have a rollup with the SUM(values)
aggregation formula that adds up the numbers from the [Recipes] table.
Sep 25, 2020 06:36 AM
Yes - this is fantastic and works very well! Thank you!
Dec 25, 2022 01:59 PM
I have trouble creating a recipe cost calculator.
I have tables:
(Ingedients) with properties {Description} , {Unit} , {Price}
(Doughs) with properties {Ingredients} , {Unit} , {Ammount} , {Cost Per Unit} , {Cost}
(Fillings) with properties {Ingredients} , {Unit} , {Ammount} , {Cost Per Unit} , {Cost}
(Expenses) with properties {Description} , {Unit} , {Price}
(Recipes) with properties (Doughs) , (Fillings) , (Ingedients) , (Expenses) , (Total Cost)
Can you help