Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Feature request: Lookup without duplicates

Topic Labels: Base design
1838 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaley_White
6 - Interface Innovator
6 - Interface Innovator

I need unique lookup values. This can only be done using a rollup field, which removes formatting. I need unique values but retained formatting.

Lookup field: Contains duplicates

Kaley_White_0-1680115338848.png

Rollup field: No formatting

Kaley_White_2-1680115466826.png

What I need: Lookup field w/ duplicates removed

Kaley_White_1-1680115409708.png

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi Kaley,

A way to use ARRAYUNIQUE() in a lookup field to dedupe values would be a great addition to the product. You're right! You can do this with a rollup field, but it does remove the formatting. I encourage you to post this idea in the Product Ideas section as I am sure others might be looking for similar functionality.