Help

Re: Remove duplicates in look up field

3709 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mathias_Elmose
7 - App Architect
7 - App Architect

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?

110 Replies 110
CodeKnight
6 - Interface Innovator
6 - Interface Innovator

Yes i need this feature, Please add it.

This solution explained solves my use case as well. I am linking tasks to multiple projects and want a lookup field that displays a unique set of links instead of duplicate links

Jean_Mertz
4 - Data Explorer
4 - Data Explorer

I came here looking for a similar solution. I hope this comment can be regarded as an extra +1 when evaluating the importance of this feature.

Paulina_Lopez
4 - Data Explorer
4 - Data Explorer

Definitely a needed feature that will make tracking data a lot easier and improve workflow, which is what Airtable is designed to do, right?

The reason I need this feature is, in my accounting base for my business, I have a table of my business assets. It is linked to my business expenses which shows the transactions when I purchased the assets. I wanted to add a lookup field to the assets table for the “cost” field of the business expenses, which would, theoretically, tell me the total value of my business assets. The reason it doesn’t, however, is because some transactions include more than one asset, so both assets link to the same transaction, and the lookup returns duplicate dollar amounts, resulting in an inflated total.

If I had the option to “only display unique records”, this would not happen, and the sum of the lookup column would actually reflect the equity in my business assets.

Without this feature, I would have to manually enter the value of each asset, based on the corresponding transaction record. Which, is not worth the time or effort.

With all the other things Airtable can do and makes easy to just add a column to get a new stat, it’s disappointing that such a simple feature with so many applications, already available in other field types, is overlooked.

Jeremie_POUTRIN
4 - Data Explorer
4 - Data Explorer

Hi Airtable product people,

I need this to cluster information together for a complex impact analysis.

the proposed solution seems fair with the little toggle.
the exposition in a formula is also cool if it does not destroy the lookup link like the ARRAYUNIQUE does today.

just for our information, how is the feature election process working?
Have you disregarded that request as it’s floating around for around 2years?

Ivan_Sarmiento
4 - Data Explorer
4 - Data Explorer

Yes! this is a very needed feature.

Subhas_Dandapan
4 - Data Explorer
4 - Data Explorer
  • What’s the use of showing the exact same “clickable link” twice in the same field? I mean, we cannot remove or add or interact with linked records other than clicking it, and if all those clicks lead to the same place – then why show the same link mulitple times?
  • => Why should there even be a “Don’t show duplicates” checkbox for linked fields?
  • => Should this be treated as a feature or a bug?

To me it feels like a Bug in the Linked Records field. It creates side effects – try “grouping” by a Lookup field, and see it grouped by the same linked record many times over with headings like “LinkA LinkB LinkA LinkA” “LinkA LinkA LinkB LinkA” … creating a nasty permutation of groups.

Is there a way to file a bug report?

Are you still able to see the “only display unique linked records” option?

I can’t see it when I structure my lookup field. Is it possible they removed this option when they added the conditional lookups?

Can anyone confirm if the option to “only display unique linked records” is still there? Thanks!

Whoops. I thought that was an actual screenshot. I guess I need to read a little more carefully…

Rebecca_Ratnam
4 - Data Explorer
4 - Data Explorer

I just ran into this problem, too. Hoping to see a solution soon. In them mean time is there a workaround?

Yeah, that was just my mockup of my proposed solution. It would seem like this would be to implement, especially given that they just added conditional filtering to lookup fields. The need for this feature keeps coming up, so it’s frustrating that it hasn’t been addressed yet.

John_Aqel
4 - Data Explorer
4 - Data Explorer

+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
4 - Data Explorer
4 - Data Explorer

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
4 - Data Explorer
4 - Data Explorer

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
4 - Data Explorer
4 - Data Explorer

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

Theia_Chari_Exp
4 - Data Explorer
4 - Data Explorer

I need that too :grinning_face_with_big_eyes:

Scott_Callery
6 - Interface Innovator
6 - Interface Innovator

+1 to this solution!

Zach
4 - Data Explorer
4 - Data Explorer

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

Cristiano_Dalbe
4 - Data Explorer
4 - Data Explorer

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

Asher_Weinstein
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 here for me too!!!

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.