Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using tags but seeing entries for every instance

Topic Labels: Base design
Solved
Jump to Solution
482 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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