Help

Calculate the total number of ingredients

Topic Labels: Formulas
1126 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Shmuel_Israeli
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I’m using the Recipe Organizer template.
I would like to add another view that calculates the total number for each ingredients.
For example:
Recipe 1 - Big Salad - consists of:6 Cucumbers and 8 Tomatoes.
Recipe 2 - Small Salads - consists of:3 Cucumbers and 4 Tomatoes.

The user needs to prepare 10 Big Salads and 4 Small Salads.

The output should be 72 Cucumbers and 96 Tomatoes.
Is it possible?

Thank you,

Sam

2 Replies 2

Take a look at this base I made for recipes/meal planners:

In the [Ingredients] table there is a Shopping List view which adds up all the ingredients necessary to make the recipes planned for the current week. It uses a series of formulas and rollups to accomplish this.

In order for my method to work, you’ll need a [Recipes] table, an [Ingredients] table, and a [Recipe Ingredients] table which stores the ingredients and quantities of them required to make each recipe. I have another table called [Meals] so that I could string together multiple recipes, but you might not need it depending on your use case.

I would encourage you make a copy of that base and explore it a little to see how you can incorporate the structure with your own.

Shmuel_Israeli
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you @Kamille_Parks for your reply.

At the end I used the “Recipe Organizer” template and added a checkbox field in the Recipes table.
In the Ingredients table I added a lookup field for this field.
Then I created a view in the Ingredients table grouped by the Ingredient, filtered by the checkbox - marked value.

Thank you again,

Sam