Duplicated Rows in Aggregated Ingredient List

[Emanuele_Caprodossi]

Hi everyone,
I’m building a shopping list app in Glide (free version) where ingredients are linked to recipes. Here’s the setup:

• I have a table of recipes and a table of ingredients.
• Each ingredient has a quantity tied to a specific recipe.
• Users can select recipes, and the app calculates the total quantities of each ingredient based on the selected recipes and their desired portions.

The Issue:
In my ingredient list, the same ingredient appears multiple times, even though the “aggregated quantity” (using a Rollup column) is correct. For example:

• Recipe 1: Oil = 40g
• Recipe 2: Oil = 1g

Instead of showing one row with “Oil: 41g”, I see:

• Oil: 41g
• Oil: 41g

I need a way to display each ingredient only once with the correct total quantity.

What I’ve Tried:

1. I created a Relation and a Rollup column to sum the quantities.
2. I tried using Group By in the list view, but I still see duplicate rows.
3. I can’t use a Slice (not available in my plan), and I don’t have Google Sheets as a data source.

Question:
How can I display each ingredient only once with the correct aggregated total quantity in Glide?

Thank you in advance for any suggestions!

[Darren_Murphy]

• Add a RowID column to your Ingredients table
• Create a multiple relation column that matches each ingredient with itself
• Use a Single Value column to fetch the first RowID value from the relation
• Create an if-then-else column:
  – If RowID is Single Value RowID, then true
• Use the if-then-else column as a filter (only show rows where it is checked)

[Emanuele_Caprodossi]

thank you very much