Here is a list of supported operators and functions that you can utilize within the platform in order to create various different formulae or expressions.
Operators
Operator |
Description |
Example |
+ | Adds two fields | 10+2 is 12 |
- | Subtracts two fields | 10-3 is 7 |
* | Multiplies two fields | 5*20 is 100 |
/ | Divides two fields | 20/5 is 4 |
% | Calculates the remainder | 20%3 is 2 |
( | Used to define mathematical formulas or conditional operations | (10+2)*3 |
) | Used to define mathematical formulas or conditional operations | (10-2)*4 |
! | Condition is negated | !{{Contact.billingcountry}}='USA' |
!= | Not equal to operator | {{Contact.billingCountry}}!='USA' |
= | equal to operator | {{Contact.billingCountry}}='USA' |
< | less than operator | {{Deal.value}}<1000 |
> | greater than operator | {{Deal.value}}>1000 |
<= | greater than or equal to the operator | {{Deal.value}}>=1000 |
>= | less than or equal to the operator | {{Deal.value}}<=1000 |
Functions
Function |
Description |
abs | Returns the absolute value |
ceil | Rounds a value to the nearest higher value integer |
floor | Rounds a value to the nearest lower value integer |
max | Returns the greater of two values |
min | Returns the smaller of two values |
sqrt | Returns the square root of the input number |
if | Returns one of two values depending on the logical condition |
len | Returns the number of characters in the provided text |
dayofmonth | Returns the day of the month for the given date |
hour | Returns the hour for the given date |
minute | Returns the minute for the given date |
month | Returns the month for the given date |
year | Returns the year for the given date |
weekday | Returns the day of the week(1-7) corresponding to the input date, where 1 is Sunday, 2 is Monday, and so on. |
&& | Returns true when both conditions match |
|| | Returns true when any condition matches |
lower | Converts all characters in a text to lower case |
upper | Converts all characters in a text to upper case |
trim | Removes extra spaces before and after the text |
subsubstring | Returns the part of text from the start position to the given length |
tostring | Returns string representation of the object |
replace | Replaces a character every time it appears in the text |
newdate | Create a date from the year, month, day, and time |
datepart | Returns just the date for the DateTime value |
timepart | Returns just the time for the DateTime value |
adddate | Returns a new date by adding (year/day/month/hour/min) to the given date |
subdate | Returns a new date by subtracting (year/day/month/hour/min) to the given date |
now | Returns a date/time representing the current time |
datecomp | Compares two dates and returns the difference of days in minutes |
tonumber | Returns number from the given string |
Comments
0 comments
Article is closed for comments.