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