INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: StFeder on September 04, 2008, 07:11:51 pm

Title: Smartlist / Calculated Data question
Post by: StFeder 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: ORDERSo 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?

Title: Re: Smartlist / Calculated Data question
Post by: Matt on September 04, 2008, 09:16:01 pm

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

The "8" means substring search, case insensitive.

Title: Re: Smartlist / Calculated Data question
Post by: StFeder 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 :)

Title: Re: Smartlist / Calculated Data question
Post by: JimH on September 05, 2008, 08:21:55 am

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

Title: Re: Smartlist / Calculated Data question
Post by: John Gateley on September 05, 2008, 09:16:17 am

Under additional options you can select "don't use smileys". -- j