Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Unique vales from Lookups

Topic Labels: Base design
560 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a BASE with an Events Table, a related Contacts Table (One to many), a Schools table related to the Contacts, and a Groups table. related to an event where a group can be associated with multiple Events.

In the Groups Table, I have a lookup that finds all the Contacts from all Events related to the group and another lookup that finds the School related to the contacts that show up in the first lookup.

Because the same people attend multiple Events related to the group, the result in both lookups have duplicate values.

My goal is 2 field that only shows the unique values present in each lookup. (Unique Schools and Unique Students) related to a group.

I looked at using UniqueArray but couldn’t get the desired result and am looking for any Step by Step help that you can provide.

1 Reply 1

Try using ARRAYUNIQUE(values) in a rollup field instead of a lookup field.