Remove duplicates in look up field

[Mathias_Elmose]

I’m a big fan of look-ups but I would really like to be able to remove records the occur more than one time. Is there a way to do that?

[John_Aqel]

+1 here. It’s my first go at using Airtable and I’m hitting this problem straight from the onset. It seems like a no-brainer to me that the deduplication feature should be implemented.

[P_D_M]

Absolutely agree that this is an important feature, the mocked up solution by @David_Krizan looks perfect to solve it. Please add support for this Airtable!

[Pilar_Concha]

Would love to see this implemented! It would solve a lot of issues I’m currently facing. And @David_Krizan’s solution seem perfect to do it :winking_face:

[Reagan_Lehman]

+1 to this solution! Need it right now for a similar situation as the original post.

[Theia_Chari_Exp]

I need that too :grinning_face_with_big_eyes:

[Scott_Callery]

+1 to this solution!

[Zach]

+1 to this feature please. The proposed “only display unique linked records” toggle seems like an elegant solution to me.

[Cristiano_Dalbe]

Although this thread is more than 2 years old and I doubt this issue will be fixed soon, here is my +1

[Asher_Weinstein]

+1 here for me too!!!

[Asher_Weinstein]

What you can do is look back through a rollup function and use the ARRAYUNIQUE(values), aggregation function to get a unique list, but this list is non functional… and if you are like me and want to build this onto a document in the Page Designer block, it will not work as you hoped it would.