Creating a rollup of records three links deep

Topic Labels: Base design
866 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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