Hello Tabidoo,
I have a calculated field that concatenates values from several other fields. If one of the source fields is empty, the calculated field shows null in the output.
Is it possible to set the calculation so that when a source field is empty, it returns an empty string (“”) instead of null - so nothing is displayed in that place?
Example:
First name: Tomáš
Last name: Fuk
Title: (empty)
Calculated field: Title + First name + Last name
Desired result: Tomáš Fuk (not null Tomáš Fuk)
Thank you.