...
ROUND(): Rounds a number to the nearest specified number of decimal places.
ROUNDUP(): Rounds a number up to the nearest specified number of decimal places.
ROUNDDOWN(): Rounds a number down to the nearest specified number of decimal places.
Contact Phone Property Access
Access contact phone-related properties using the new array properties: phoneNumber, phoneType, and phoneExtension. You can now access these properties directly without using array notation.
For example, instead of CONTACT.phoneNumber[0], you can use CONTACT.phoneNumber or first(CONTACT.phoneNumber).
To display a "home" phone number, use the following formula:
| Code Block |
|---|
lookup(`CONTACT`.phoneType=='Home', `CONTACT`.phoneNumber) |
The phones property is deprecated. Replace any references to phones with phoneNumber, phoneType, or phoneExtension in your formulas.
Formatting Dates
Date formats control how dates are displayed. The FORMAT() function enables formatting dates according to various styles.
...