Skip to main content

The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?

+1 for "display unique values" toggle on the lookup field formatting options. Becomes absolutely essential with multiple levels of a linked record hierarchy.


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