Re: Unique vales from Lookups

695 1
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

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.

2 Replies 2

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

Hi 👋I came up with a pretty satisfying solution using the Scripting automation. You can find it here