This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Feature request: Lookup without duplicates

Topic Labels: Base design
925 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