Conditional Formulas in Calculated Fields

Dear Crocoblock-Team,

I have a question regarding conditional formulas in calculated fields.

Let’s say I have two fields:

1) A select field with the field name “business_model” and the two values “B2B” and “B2C”

2) A calculated field with the following formula:

( %FIELD::business_model% == ‘B2B’ ) ? 50 : 10

Even if I select “B2B” in the select field, 10 is displayed.

Is it possible that such conditions do not work with text values?

If I give them a numerical value, e.g. 1 for “B2B” and 2 for “B2C”, then at least this formula works:

( %FIELD::business_model% == 1 ) ? 50 : 10

However, it is not very practical to select numerical values because these are also sent (e.g. by email) instead of the actual select field names.

• This topic was modified 1 year ago by Manuel.