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?
Oct 05, 2020 04:48 AM
+1 for me too! This would be a very interesting feature to implement.
Nov 04, 2020 07:20 PM
+1 this feature seems necessary.
Airtable folks, please post a workaround here if there is one available. Thanks!
Nov 18, 2020 07:03 AM
+1 pretty please!! I have the same problem and I can’t find a workaround.
Dec 15, 2020 03:08 PM
+1. This seems like one of those low effort/high delight features. Seems like an easy win for the product team. Let’s keep this thread fresh!
Dec 17, 2020 04:11 AM
+1 for me as well! I’ve had multiple use cases where this comes up. Thanks!
Dec 18, 2020 04:55 AM
I know I posted in this topic before, but I keep running into this annoying problem. Structuring my research database would be so much easier if it wasn’t for this issue. Why would you ever want to have duplicates in a lookup field?
Dec 18, 2020 07:43 AM
I agree that the Airtable engineers dropped the ball with this one, and sadly, they seem to be unresponsive to user feedback like the comments in this thread.
There is one partial workaround to this dilemma, but it doesn’t provide the full functionality of lookup fields (which have now become clickable items in Airtable):
Dec 18, 2020 01:03 PM
Would be great to have this feature.
Jan 05, 2021 09:47 AM
Hello community!
Adam from the Airtable customer support team here. I had an Airtable user reach out with a link to this community post. While I can’t speak to a specific timeframe for when this feature might be available I have a workaround that may help.
I used the Recipe, Ingredients, and food type example from earlier in the thread. Also, you will need to have some comfort with our Automations feature in order to use this method:
Jan 12, 2021 02:28 PM
Although it doesn’t resolve the underlying issue, I found this to be very useful.
Thanks for posting!
Jan 25, 2021 03:17 PM
It IS a workaround, but it’s not very scalable, as creating 3 additional fields and an automation for what is essentially a field-level filter is not a particularly elegant solution. And then good luck trying to explain that workflow to a non-experienced user. The simplest solution is to not make users think or create a Rube Goldberg machine to do something that really should be a no-brainer.
And this also goes for linked records on the same table. Please give us a simple switch to allow the linkage to apply to both records. For example, if I have a Software table and have a same-table linked record field called Integrations, if I use this field to link Airtable to Zapier, I’d want an option (at the field-level) to make this a two-way linkage so that Zapier is also linked to Airtable in this instance.
Mar 09, 2021 07:24 AM
+1 really need this feature…
Mar 19, 2021 08:05 PM
Here to join the party, I’ve also just come across this need. Trying to organise references and research for individual animal species, but view easily overall content within their families.
Having this feature would be the final puzzle piece.
Mar 29, 2021 02:10 PM
+1 to this feature too.
Apr 16, 2021 08:36 AM
+1 to the above, this is a sorely needed filter
May 05, 2021 12:57 PM
+100000 to the above… been waiting for this for a loooong while.
May 06, 2021 01:58 AM
+1 to this feature too.
May 07, 2021 03:59 PM
+1 to this feature - very much needed.
May 28, 2021 06:59 AM
+1 this would solve a lot of issues and prevent the need to use hacky workarounds that aren’t scalable
Jun 22, 2021 11:51 PM
Adding my +1. This feature prevents our organization from really using this as it would be integral to a lot of the tables we would need to create. The current workaround is not feasible at scale.