Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[StFeder]

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?

[Matt]

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

The "8" means substring search, case insensitive.

[StFeder]

I got it working 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

[JimH]

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

[John Gateley]

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