Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Removing duplicates from lookup fields

1526 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Y_S
6 - Interface Innovator
6 - Interface Innovator

Is there a way to set up a lookup field without duplicates? I asked this here and I just noticed that the response didn’t fully solve the issue: The rollup formula ARRAYUNIQUE(values) still includes duplicates.

image

image

5 Replies 5

I’m not 100% sure if this will work, but you may want to try this formula to see if it works for you:

ARRAYUNIQUE(ARRAYFLATTEN(values))

Y_S
6 - Interface Innovator
6 - Interface Innovator

Hmm this doesn’t do the trick. Any other suggestions?

Add a formula field containing ARRAYUNIQUE({Purpose (from Interventions}). This should work.

Uk49s_Results
4 - Data Explorer
4 - Data Explorer

Read this discussion. May be this can help you here https://community.airtable.com/t/how-can-i-make-a-lookup-field-show-only-unique-results-uk49s. If yes then please mentioned me here.

Aaliyan_SEO
4 - Data Explorer
4 - Data Explorer

Well I had the same question becasue of same issue. Thank you to Scott for the answer