INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: ozmael on January 11, 2006, 02:55:10 pm

Title: Change in behaviour of calculated fields in recent 11.1 builds?
Post by: ozmael on January 11, 2006, 02:55:10 pm

In recent builds of 11.1, I've noticed a change in the behaviour of calculated fields.

I have a calculated field called [Name (Full)] which has the following formula (note the extra square brackets around 'Mix Name'):

[Name (Base)] [[Mix Name]]

Formerly, when a song didn't have a value in the [Mix Name] field, the calculated field would ignore the extra square brackets around [Mix Name] and return just the value from [Name (Base)].

In recent builds of 11.1, when the [Mix Name] field is blank, I get an extra set of empty square brackets after the song name as in:

Let the Sunshine In []

Is there any way to instruct MC 11.1 to ignore the extra square brackets when the [Mix Name] field is blank?

Regards

Title: Re: Change in behaviour of calculated fields in recent 11.1 builds?
Post by: skeeterfood on January 11, 2006, 04:09:25 pm

Try this:
[Name (Base)]If(IsEmpty([Mix Name]),, [[Mix Name]])
Note: There probably won't be a space between [Name (Base)] and [[Mix Name]], since the documentation claims that spaces after ','s are ignored...  Not sure how to deal with that...

For more details see: DevZone (http://www.jrmediacenter.com/DevZone/DBExpressions.htm)

-John