Help

Remove duplicates in look up field

58987 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?