Group by / Unique Values

[Kyle_Shaffer]

I have 3 columes in my table formatted as such: A Linked record field + 2 look up fields from the linked record. (crossed out proprietary info)

this linked record field shows all clients that been accepted by this playlist. The client may show up multiple times if they have been accepted by the playlist more than once or for different projects. This is fine.

The problem then comes in the artist genre and genre/moods look up fields which reference multiselect fields from the a different table. The genre and moods fields will list multiselect values multiple times because of the multipile records that have been accepted by the playlist. I am trying to show unique values for these two look up columns, but cannot seem to figure out how.

[ScottWorld]

It’s unclear whether this is possible to accomplish in Airtable, or if Airtable even supports this. I’ve gotten this to work in one base, but not in another base. I discuss my success with this in the thread below, but I cannot consistently reproduce my success:

Show unique values from multiple field from a linked table Ask the community

Hello, i’d read all discussions here to resolve my issue and nothing work, how i can get it done with this discussion :slight_smile: for this i created two tables, one contain survey results and the second contain users entries, they add their profil and based on automation airable add via the linked field all similar profil, until this point all is good. For one of the survey questions, i asked people for main daily missions they do (multiple select field), when i check the lookup or rollup f…

[JAN]

Hi, if you are looking toget unique value from a multi select field then forgot about it ^^

[kuovonne]

This is interesting. I looked up an old base where I was able to get list of unique linked multi-select values. The system worked with a combination of a lookup field and a formula field with ARRAYFLATTEN() and ARRAYUNIQUE(). However, that base is now acting inconsistently. I have contacted Airtable support with the issue.

[Kyle_Shaffer]

Thanks all - I have tried all of these proposed solutions. Even something as simple as adding a formula column with ARRAYUNIQUE(Artist Genre) doesnt do anything.

Seems like this should be a straight forward fix but nothing works.

[mrvc]

This would be so simple with a checkbox to 'split multiple values'. Official response from airtable and the suggested workaround is poor — create views for every multiselect item which would be super tedious!
https://support.airtable.com/docs/multiple-select-field

I suggest visiting that support article and responding to the page with feedback about how poor this suggested workaround is and proposing to add a checkbox that splits multiple values into individual groups