Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Removing duplicates from lookup fields?

182 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to set up a lookup field without duplicates?

image

5 Replies 5

Hi @Y_S

Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates

Hmm what should I put in the formula box?

image

Just like that it should work

Turns out i needed to do like this for it to work
image

Yes, you shouldn’t have removed “values” from inside the bracket, I didn’t notice it in the first screenshot :slightly_smiling_face: