Print

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

[ChrisRainman]

Hope that someone can help on this one:

How can I compare against empty fields in the IF database expression?

Example:

IF(ISEQUAL([Album],""),C:\Tracks,C:\Albums)

That's the way I would like to have it but seems not possible (as "" is not interpreted as empty)

Is it possible to use an IF-expression within an IF-expression? (This would be very useful if you want to have more than two decision paths).

[Matt]

We'll add IsEmpty(...) to the next build.

[Herakles]

Yes, it's possible to have multiple ifs. I use this formula and it works perfectly for me:

If([Complete Album],If(IsEqual([Disc #],0,2),Complete Albums\[Album Artist (auto)]\[Album],Complete Albums\[Album Artist (auto)]\[Album]\Disc [Disc #]),If(IsEqual([Disc #],0,2),Partial Albums\[Album Artist (auto)]\[Album],Partial Albums\[Album Artist (auto)]\[Album]\Disc [Disc #]))