Creating a rollup of records three links deep

I’m developing a simple app to manage my family’s food planning. My current structure is Recipes (e.g., Crockpot Chicken Tacos) that have multiple Ingredients (Chicken, Cream Cheese, Cumin, etc), and Plans that essentially have a date and a recipe associated with it (Tuesday through Thursday is the Crockpot Chicken Tacos recipe).

I wanted to add some way to create a shopping list draft by creating a Trip entry referenced in a bunch of Plans, then going through those Plans, getting all Recipes, and then getting all Ingredients associated with the Recipes. I was thinking this could be done with a Rollup using ArrayUnique or something like that on the Ingredients lookup field of the recipes, but I still end up with duplicates. Is there some better way to do this rollup?

Check out these 2 threads and see if they help solve your issue:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.