Creating a rollup of records three links deep

[Mark_Miller2]

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?

[ScottWorld]

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

Remove duplicates in look up field Ask the community

Hello community! Adam from the Airtable customer support team here. I had an Airtable user reach out with a link to this community post. While I can’t speak to a specific timeframe for when this feature might be available I have a workaround that may help. I used the Recipe, Ingredients, and food type example from earlier in the thread. Also, you will need to have some comfort with our Automations feature in order to use this method: Hope this helps and know that our team is ver…

Removing duplicates from a string Formulas

Using ARRAYFLATTEN can be tricky. When using it in a rollup to count unique items across lin with linked records, you need to use it in a rollup of a lookup, not a rollup of a linked record field. [image] ARRAYUNIQUE(ARRAYFLATTEN(values)) I tried to search these forums for the thread where this particular use case was explained to me to give credit, but I couldn’t find it. Note that ARRAYUNIQUE(ARRAYFLATTEN(features)) works differently, depending on what type of field is being rolled up.