More > JRiver Media Center 24 for Windows

expression help list of favourites and using populating calculated field

(1/6) > >>

lise:
How can I extract info from a field and have it populate a different custom field?

I have two custom user fields: "Fave Albums" and "Fave Artists".
I use them for the relational aspect of storing the info just once per artist or per album. That way, when I set Blue Rodeo as one of Jonnie's favourite artists (just by tagging a single Blue Rodeo track), all the Blue Rodeo tracks, including future ones I might add, will show up when I select "Fave Albums>Jonnie".

Note: inline images aren't working in preview so I have no clue if they will show up.
Edit: ok, the images didn't display inline.

But I prefer to the following custom field to deal with all the favourites (see image 2). So I want to turn the two fields above into calculated data fields, where they would get their content from my other field called "Favourites". If "Jonnie Albums" is checked in the Favourites field, then the calculated data in "Fave Albums" would list "Jonnie".

My solutions (that I can't get to work):

To populate the calculated fields I tried a few a few iterations of "if is equal", but the second condition always gets filtered by the first, such that if we both have the same album in our favourites list, it shows up in the first condition (Jonnie) but not the second (Lise). I don't know my way around it. I've tried multiple iterations of the following code based on the wiki. Here is just one that didn't work:


--- Code: ---if(isequal([Favourites],Jonnie Albums,8),Jonnie albums,if(isequal([Favourites],Lise Albums,8),Lise Albums,unassigned))
--- End code ---

Then I tried else in many different configurations but still couldn't get it to work:


--- Code: ---ifelse((isequal([Favourites],Jonnie Albums,8), Jonnie albums, (isequal([Favourites],Lise Albums,8), Lise Albums)
--- End code ---

If anyone can help with the code, that would be much appreciated. But if there is a simpler solution that doesn't require the separate calculated lists that would be even grander.

JimH:
Hi lise!

lise:
Hey Jim. I've been thinking about you. Was thinking about how you (and I) have it pretty good during Covid, living in the boonies (assuming you are still at the same place).  Also, I missed the special deadline to upgrade for the very first time ever! In how many years.... geez, we're talking Media Jukebox!

JimH:
You've got mail, lise.  I'm even further out.  Nobody.  It's great.  Still waiting for you to find me a spot next to the marina so I can finish up rocking and watching people park their boats.  How's Jonny?

lise:
Aw, you are so sweet. Thank you. I was just mentioning it because it was another reason I was thinking of you and the whole crew.
Jonnie is good. We are totally out of Toronto now, though, and live exclusively in the country outside Peterborough. Sold the condo a while back. 100% country bumpkins now. We have our cinema in the basement and our indoor hydroponic garden upstairs. Movies and Food. Is there anything else? (aside from tunes, of course!). I hope your daughters are well.

Navigation

[0] Message Index

[#] Next page