Yup, that is one approach, but it will require for me to tag every one of my albums. That is certainly do-able, but not preferred as I am lazy - i would prefer to just tag albums with artists who have firstname lastname . So, can I get MC to do my work for me?
I am wondering about a different approach: I have my Artist Sort Order field already populated for all named artists as last name, first name. That shows up in my tags (see attachment) but I do not have albums like Third Eye Blind tagged (yet!). I am trying to have MC fill in a new field named Artist View Order using the calculated area expression so that if the Artist Sort Order field is empty, it populates the Artist View Order field with [artist] and if Artist Sort Order field is not empty, then i want it to fill Artist View Order with the Artist Sort Order data. Here is my calculation.
if(isempty([artistsortorder],0),[artist],[artistsortorder])
but no matter what is in the artistsortorder field, I get returned "[artistsortorder]" (without the quotes, but with the brackets) in the calculated Artist View Order field. In the attachment you can see that Artist Sort Order is clearly populated with Hendrix, Jimi, but I get "[artistsortorder]" (without the quotes, but with the brackets). If I have Third Eye Blind selected, the field artistsortorder is empty, but the calculation is behaving returning "[artistsortorder]" (without the quotes, but with the brackets) (see attachment).
So obviously I am missing something. Can I do a calculation on the artistsortorder field? If so, what is wrong with my expression?
Again, many thanks for all the help MC is an awesome program the power of which I am just beginning to appreciate.
Norm