Formula emtpyfield

[MicKress]

Hi, what ist the expression in formula for an empty varchar type field. I tried field=='' and field==null, but nothing happened. I need this for an ifThen expression (ifThen (field=='', expression1))

[Maximus]

Hi.
It works perfectly. ifThen(testtext == null, sicCode = 2)

[MicKress]

Hi, my formula is

ifThenElse(salutationGenderName=='Frau' && salutationForm=='familiar' && nickName == null, salutationLetterText=string\concatenate("Liebe ",firstName), salutationLetterText=string\concatenate("Liebe ", nickName)); ifThenElse(salutationGenderName=='Herr' && salutationForm=='familiar' && nickName == null, salutationLetterText=string\concatenate("Lieber ", firstName), salutationLetterText=string\concatenate("Lieber ", nickName));

That doesn't work.

[MicKress]

I see, it was the wrong forum, sorry. I wanted to write the post under general discussion, but obviously I clicked the wrong part.

[Maximus]

The formula seems to be correct. Have you checked the error log file? Is there everything good with the indentation in the formula?

[MicKress]

Now it works, thank you. Don't know what happenend ...