INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Conditional function in calculated field?  (Read 1203 times)

ozmael

  • Regular Member
  • Junior Woodchuck
  • **
  • Posts: 51
  • Change this by choosing profile
Conditional function in calculated field?
« 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,
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9140
Re: Conditional function in calculated field?
« Reply #1 on: October 21, 2006, 04:54:14 am »

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

official database expressions page
Pages: [1]   Go Up