Sorting by First Name

Discuss using and your tips/tricks for CATraxx
Post Reply
Gman
Posts: 3
Joined: Fri Jun 19, 2020 9:48 am

Sorting by First Name

Post by Gman » Fri Jun 19, 2020 10:08 am

Gosh, first time back on a Catraxx for many many years, and great to see so many familiar names!

I'm sure this must be simple to do but somewhere along the line I seem to have lost the help section, and I just can't seem to figure it.

What I'd like to do is in Album View be able to set up a grouping that sorts artists by their first name, driven by Artist (at the moment it's last name).

I won't list what I've tried as I've confused myself now, and no longer sure what I've done or thought of doing!
Many thanks in advance

User avatar
DougWilliams
Site Admin
Posts: 346
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Sorting by First Name

Post by DougWilliams » Fri Jun 19, 2020 10:37 am

As there is only a Name and Sort By field, short answer is "you can't".

You could populated a custom field in the Album form with a first name and use that to group.
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Gman
Posts: 3
Joined: Fri Jun 19, 2020 9:48 am

Re: Sorting by First Name

Post by Gman » Fri Jun 19, 2020 11:27 am

Thanks Doug! Least I now know I'm not going mad!

Can I populate that field with existing data? Been fiddling but can't seem to click how. (I have c. 110,000 tracks)

User avatar
DougWilliams
Site Admin
Posts: 346
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Sorting by First Name

Post by DougWilliams » Fri Jun 19, 2020 12:36 pm

You going mad is still an option! :D ;)

A custom query, the Custom field to use, and a definition of "First Name" would need to be created.
(ie first word up to the first space of "Name" or anything after the last comma of the Sort By)
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Gman
Posts: 3
Joined: Fri Jun 19, 2020 9:48 am

Re: Sorting by First Name

Post by Gman » Fri Jun 19, 2020 1:24 pm

I think that sounds like something I shouldn't be attempting when I'm supposed to be working!
Thanks again, and I'll go play now you've pointed me in the right direction.

Post Reply