Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Fri, Nov 14 2014 7:34 AM	Permanent Link
Mike	Hi, I would like to have the following field calculated. if salutation_id= 1 then salutation:= "Mister" else salutation:= "Madam"; What is the correct syntax to use the statement as computed field? Kind regards, Mike
Fri, Nov 14 2014 8:10 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Mike >I would like to have the following field calculated. > >if salutation_id= 1 then > salutation:= "Mister" >else > salutation:= "Madam"; > > >What is the correct syntax to use the statement as computed field? Being an SF addict I'd recommend just use "ser" that covers both alternatively IF(salutation_id=1,Mister','Madam') should work Roy Lambert
Fri, Nov 14 2014 9:03 AM	Permanent Link
Mike	Hi Roy, Thank you. That did the trick. Regards, Mike