Oct 02, 2018 02:57 AM
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?
Jan 24, 2020 12:19 AM
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
Feb 03, 2020 10:29 AM
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.
Mar 23, 2020 01:47 PM
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.
Apr 10, 2020 01:59 AM
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?
Apr 30, 2020 02:09 PM
Yes! this is a very needed feature.
May 07, 2020 07:05 AM
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?
May 08, 2020 08:51 PM
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!
May 09, 2020 12:29 PM
Whoops. I thought that was an actual screenshot. I guess I need to read a little more carefully…
May 13, 2020 01:00 PM
I just ran into this problem, too. Hoping to see a solution soon. In them mean time is there a workaround?
May 18, 2020 10:43 AM
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.
May 27, 2020 01:37 AM
+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.
Jun 04, 2020 07:18 AM
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!
Jun 11, 2020 04:51 PM
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:
Jun 26, 2020 07:50 PM
+1 to this solution! Need it right now for a similar situation as the original post.
Jul 10, 2020 04:42 PM
I need that too :grinning_face_with_big_eyes:
Jul 13, 2020 07:05 AM
+1 to this solution!
Aug 11, 2020 04:27 AM
+1 to this feature please. The proposed “only display unique linked records” toggle seems like an elegant solution to me.
Aug 22, 2020 09:28 AM
Although this thread is more than 2 years old and I doubt this issue will be fixed soon, here is my +1
Sep 01, 2020 06:38 AM
+1 here for me too!!!
Sep 01, 2020 06:43 AM
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.