The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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?
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.
