
- 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
‎May 13, 2022 12:30 AM
+1 from me also! It would help greatly

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 06, 2022 03:07 PM
+1 it’s kinda ridiculous at this point

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 07, 2022 04:58 PM
+1 for that one !!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 10, 2022 12:56 PM
+1 For this useful switch!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 10, 2022 01:42 PM
It’s a bug in Airtable.
But you can get the desired effect by creating a rollup field instead of a lookup field, and using the formula:
ARRAYUNIQUE(values)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2022 09:04 AM
Please airtable add this feature!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2022 09:12 AM
Airtable employees do not see these messages. Be sure to send your feature requests to support@airtable.com.
In the meantime, you can achieve similar functionality by creating a rollup field with the formula:
ARRAYUNIQUE(values)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 02, 2023 07:24 AM
Maybe people should read the case before suggesting Arrayunique, which is not a solution (you don't have linked records)
I'd love to see this feature (a "display only unique linked records" toggle)
Forever bumping this thread, 1612 days after it was posted
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 23, 2023 02:01 PM
+1. This is pretty basic. I agree that the duplicates seem more like a bug than a feature - I guess maybe there's a use case where that would be helpful but I can't think of one. Adam Minich's workaround on page 3 seems like the best option, but still isn't great.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 05, 2023 11:42 AM
Just thought I would add myself to the dozens of users requesting the very simple solution of allowing us to filter out duplicates from lookup fields.
Very disheartening as a relatively new enterprise account manager that this functionality is not available, and that is has been requested for 3.5 years with no response from Airtable.
