I’m using the Recipe Organizer template.
I would like to add another view that calculates the total number for each ingredients.
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?
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.
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.