Skip to main content

Hello community!

I have a problem, which I've been unable to resolve myself.

I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).

Now, in the first table (table 1) with different entrees all entrees have a name connected to it.
But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).

Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.
Hope my explanation is clear.

Does anyone know how to do this?

Hi @UrbnJ,

Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.

Rollup Field - Overview | Airtable Support


Hi @UrbnJ,

Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.

Rollup Field - Overview | Airtable Support


Thanks for this solution. It works perfectly.


Reply