Help

Using tags but seeing entries for every instance

Topic Labels: Base design
Solved
Jump to Solution
1411 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Danny_hearn
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,
I’m using tags in a table to create groups for records e.g. ‘homepage’ , ‘landingpage’ ‘checkout’ . In a one to many relationships.

So, for instance, I have a table that has

Observations | Tags
record 1 | Homepage
record 2 | Homepage
record 3 | Landing page

Then in another table I’m seeing

Insight | Observations | tags
Name | record1, record, 2 | Homepage, Homepage

What I want is it to do

Insight | Observations | tags
Name | record1, record, 2 | Homepage

When I do a lookup on the tags on a separate table. What I see is a record with the same tag repeated several times as it is linked to several other records. How can I make it only display an associated tag once rather than for every instance?

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Danny_hearn,

Welcome to Airtable Community !

Instead of Lookup use Rollup and in the Aggregation formula use ArrayUnique

BR,
Mo

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Danny_hearn,

Welcome to Airtable Community !

Instead of Lookup use Rollup and in the Aggregation formula use ArrayUnique

BR,
Mo

Thank you! that worked perfectly