Combining functions
This section lists some examples of expressions combining multiple functions.
Example 1
if (isEmpty(Personnel.'First Name')) then toUpper(substring(Personnel.Initials,0,1)) + "." else Personnel.'First Name'
Example data | Result |
|---|
First Name = Adrian, Initials = “A.P.” | Adrian |
First Name = “ “, Initial = “a” | A. |
Example 2
if (Orders.'Number of people' > 8) then "Extra staff (" + numToString(Orders.'Number of people') + " visitors)" else ""
Example data | Result |
|---|
Number of people = 8 | “ “ |
Number of people = 10 | Extra staff (10 visitors) |