Calculated Expression | New Property to Class

[Deepak.SinghZYRM6]

Hello,

In 2023, we can add property type as Calculated and concatenate multiple properties to it. My question is, can we implement IFF statement to it?

Example: IFF((Description=''),Supplier|| ''|| Manufacturer, Supplier||''||Manufacturer||"|Description)

I have added the expression to field and it has accepted it but expected result not seen when component placed.

Any insights on this it would highly appreciated.

[h_eger]

Dear @Deepak.SinghZYRM6 ,

The idea itself is very good, but unfortunately the functions for it are not included:
as a function is available:
Substring
ToUpper
ToLower
ToString
ToNumber

as Opperation Symbols is available:
|| Concatenate
( Left Bracket
) Right Bracket
+ Add
- Substruct
* Multiply
/ Divide

unfortunately no IFF included.

[Deepak.SinghZYRM6]

Hello Eger
Thanks for the update on this thread.

It would be great to have this enhancement to support IIF as this is very common requirement for a tag where we have more than one or two properties as Null.

Thank you so much for providing rest of the details on this implementation.

Regards | Deepak Singh