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.