INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: ozmael on October 20, 2006, 03:59:25 pm

Title: Conditional function in calculated field?
Post by: ozmael on October 20, 2006, 03:59:25 pm

I've got a calculated field called 'Name (Full)':

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

where 'Name (Base)' and 'Mix Name' are user fields. I'm trying to get Name (Full) to look like:

Proud [Babylon 2005 Remix]

This works if there is a value in the Mix Name field but when their isn't a value I get:

Proud []

Is there function or other way that I can remove the double square brackets when there isn't a value in the Mix Name field?

Regards,

Title: Re: Conditional function in calculated field?
Post by: marko on October 21, 2006, 04:54:14 am

[name (base)] if(isempty([mix name]),,[[mix name]]

official database expressions page (http://www.jrmediacenter.com/DevZone/DBExpressions.htm)