
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 21, 2018 01:44 AM
That’s a great idea for a solution and exactly my thought @David_Krizan
The Ingridients example is great to illustrate the problem when the same ingrident appears multiple times.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 07, 2019 02:56 PM
I just want to chime in here to say that I have exactly the same problem. I have duplicates in lookup fields but can’t use rollup because I want to have the links to the actual records. Really, I don’t see why one would want to have duplicates in a lookup field ever.
If someone has figured out a workaround for this it would also be much appreciated!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2019 06:36 PM
Yes, cant find a fix for this. If anyone has any ideas let us know! Would love to see the platform updated to address this.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2019 10:11 AM
Seriously Airtable, just add an “Only display unique linked records” switch when someone selects a Linked Record field from a Lookup field. This would be so useful and seemingly so easy to do because (1) y’all would know when a Linked Record field is being selected from a Lookup field, and (2) this should just be a simple filter.
Simple Mockup of Proposed Solution
I absolutely love that Linked Record fields can be used in Lookup fields, but I have NEVER ONCE wanted duplicate linked records displayed in a Lookup field, as any redundancy negates the utility of such. This problem comes up frequently and prevents me from doing some very useful things with my data.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 24, 2019 05:27 PM
I’ve been keeping an eye on this for some time. Has anyone found a workaround or come across a product update I’m not aware of? It’s rather frustrating.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 27, 2019 05:58 PM
I’m looking for the same solution but there doesn’t seem to be a solution. Does Airtable actually go through these forums?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 29, 2019 01:59 PM
You can make an instant Zap in Zapier that Zaps the text from the Rollup to a Linked field as a workaround for this for now.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 09, 2019 02:01 PM
I ran into this problem too.
Here is my solution for the recipe example:
Make a hidden field in the Ingredients table that is a formula that duplicates the value of Ingredients -> Type, let’s call it “Type String”, then do a Lookup ARRAYUNIQUE() of Ingredients > Type String and it will work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2019 04:21 PM
This is a “must have” feature. It’s crazy to have the same link replicates several times. It’s just a filter over the top (underlying data can still be there) to make several of my views so much more valuable to users.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 06, 2020 02:55 AM
Agreed. This is a “must have” for me.
