INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Smartlist / Calculated Data question  (Read 1369 times)

StFeder

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1493
  • Fight! You may win. If you don't, you already lost
Smartlist / Calculated Data question
« on: September 04, 2008, 07:11:51 pm »

For my dancing lessons I tried to set up a smartlist wich gives me a set of all the ballroom dances we have to dance. After one hour I got it working:
Code: [Select]
~mix=8,25%,{[Comment]=[Cha Cha"},25%,{[Comment]=[Rumba"},25%,{[Comment]=[Samba"},25%,{[Comment]=[Jive"}
Sort: ORDER
So every Dance appears 2 times in the list. A problem I have is the sorting. They have to be sorted in the order they appear on our contests. Adding a calculated field called "ORDER" did the trick for me... nearly. This is how I did it:
Code: [Select]
If(IsEqual([Comment], Samba, 1), 01, If(IsEqual([Comment], Cha Cha, 1), 02, If(IsEqual([Comment], Rumba, 1), 03, If(IsEqual([Comment], Paso Doble, 1), 04, If(IsEqual([Comment], Jive, 1), 05, xx)As you can see I stored the dance information in the comment tag. A Problem I don't find a solution for: a great part of my dance songs do have some extra information stored in the comment tag like "Samba (slow)" or "Samba (44 BPM)". Because of this I am using [Jive" instead of [Jive] within the smartlist. The [" doesn't work for calculated fields (or I am to stupid to use them).

So I don't get them sorted the right way. Does anyone have any idea/hint for me in this case?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42027
  • Shoes gone again!
Re: Smartlist / Calculated Data question
« Reply #1 on: September 04, 2008, 09:16:01 pm »

Use: IsEqual([Comment], Samba, 8)

The "8" means substring search, case insensitive.
Logged
Matt Ashland, JRiver Media Center

StFeder

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1493
  • Fight! You may win. If you don't, you already lost
Re: Smartlist / Calculated Data question
« Reply #2 on: September 05, 2008, 07:42:32 am »

I got it working 8) Thanks for this tip!! Saves me a lot of time! I'm always impressed, even after using MJ/MC for many years, what "special" features are hidden in MC :)
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 71603
  • Where did I put my teeth?
Re: Smartlist / Calculated Data question
« Reply #3 on: September 05, 2008, 08:21:55 am »

For anyone else, the forum converts "8 )" to 8) (if you remove the space).
Logged

John Gateley

  • Citizen of the Universe
  • *****
  • Posts: 4957
  • Nice haircut
Re: Smartlist / Calculated Data question
« Reply #4 on: September 05, 2008, 09:16:17 am »

Under additional options you can select "don't use smileys". -- j
Pages: [1]   Go Up