Please help by formula

[peterberlin]

Hi,

This code does not work. Field briefanrede is a text field.

ifThenElse(briefanrede == null,
ifThenElse(salutationName == 'Herr', briefanrede= 'Sehr geehrter Herr ');
ifThenElse(salutationName == 'Frau', briefanrede= 'Sehr geehrte Frau ');
ifThenElse(salutationName == 'Herr Dr.', briefanrede= 'Sehr geehrter Herr Dr. ');
ifThenElse(salutationName == 'Frau Dr.', briefanrede= 'Sehr geehrte Frau Dr. ');
);

Without the first function, of course.
peter

[tanya]

Hello
not sure, but here is my thoughts
1) briefanrede == null => briefanrede == null || briefanrede == ''
2) salutationName == 'Frau'... => you need to use the key value, not the translation

[peterberlin]

thank you.