Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove duplicates in look up field

66905 112
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?

112 Replies 112
JenniferMM
4 - Data Explorer
4 - Data Explorer

Just another person +1ing the need for this feature, years and years later.

I get that there's a work around and I'm sure with enough time and focus I could figure out how to do it, but as someone who is constantly bringing organizations I work with to airtable, it would be great to have a way to do this clearly useful function without having to have a fundamental understanding of coding/programming to make it happen. 

Tito_Alverio
6 - Interface Innovator
6 - Interface Innovator

Sharing the simplest way I found to do this without the need for scripting or automations. Copying my email to Airtable support:

This was resolved to my expectations by taking the following steps:

  1. Create the rollup field in Table A on the Linked Table B’s field I want to rollup, in this case a multiselect field.
  2. Take that same rollup field that was just created, and change it to a Lookup field.
    1. (The lookup field will now display as text, instead of the colorful word bubbles you usually see from multi-select fields)
  3. Create a formula field in the Table A, and ARRAYUNIQUE the “formerly a rollup now a lookup field” field.
  4. Ta-da

Is Airtable aware of this strange behavior? If so, can we make it simpler and more intuitive to get unique values out of rollup or lookup fields?