Create a new view filtered with unique values of specific column

Topic Labels: Formulas
746 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table that are songs that we have worked, the artist, and other information. There are many duplicates as it is possible we work the same song and artist multilpe times. I want to create a view to show unique values only in the artist column. The way we have this set up with the API, Related records does not make sense in this instance.

I know I can group by artist, but it is just not clean or prety. How can I create a view that just has unique values of a specific column?

1 Reply 1

The easiest way to deal with this would probably be to convert your artist column into a linked field to another table, and you could then refer to that table for the list

If you don’t want to refer to that new table for the list, you’d have to do a bunch of weird workarounds to make sure each artist only shows up once but that would make things more complicated to set up