Help

Feature request: Lookup without duplicates

Topic Labels: Base design
1626 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Kaley_White
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎Mar 29, 2023 11:45 AM

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

Reply
1 Reply 1
Vic_Airtable
Community Manager
Community Manager
See Solution in Thread

‎Apr 05, 2023 08:10 AM

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.
 

Reply
Copyright © 2024 Khoros, LLC