Text Functions
| Function | Output | Syntax |
| Replace | String, after replacing the old value with the new value in the BaseString. | Replace( BaseString, OldValue, NewValue ) |
| Substr | Substring of the input string starting from a specified position with a specified length. | Substr( String, From, Length ) |
| Split | String array of substrings from the input string which is delimited by a specified Delimiter. | Split( String, Delimiter ) |
| Trim | String, which results from the leading and trailing spaces being omitted from the input string. |
Trim( String ) |
| LeftTrim | String, which results from the leading spaces being omitted from the input string. |
LeftTrim( String ) |
| RightTrim | String, which results from the trailing spaces being omitted from the input string. | RightTrim( String ) |
| PadLeft | String, after adding a pad character added to the left of the input string. | PadLeft( String, WantedLength, PadChar ) |
| Format | String, formatted according to instructions contained in the style string. | Format( Expression, Style* ) |
| Lower | String, converted to lowercase. | Lower( String ) |
| Upper | String, converted to uppercase. | Upper( String ) |
| WCase | String, converted to wordcase, where the first character of the input string is in uppercase and all the others are in lowercase. | WCase( String ) |
| Index | Index position of the search text within the input string. | Index( String, SearchText, Delimiter ) |
| Len | Length of the the input string. | Len( String ) |
| Chr | The character associated with the specified integer character code. | Chr( IntValue ) |
| ChCR | A carriage-return character. | ChCR() |
| ChLF | A linefeed character. | ChLF() |
| ChCRLF | A carriage-return character combined with a linefeed character. | ChCRLF() |
| If | TrueValue object if the boolean condition is true, else FalseValue object. | If( Boolean_Condition, TrueValue, FalseValue ) |
| Inlist | True if search text is present in the list string delimited by a specified delimiter, else False. | Inlist( SearchText, ListString, Delimiter ) |
*Style argument for the Format function may be set as:
|
Style |
Description |
|
Currency |
Displays number with thousand separator, if appropriate; displays two digits to the right of the decimal separator. Output is based on system locale settings. For example, Format(1234567, "Currency") returns $1,234,567.00. |
|
Fixed |
Displays at least one digit to the left and two digits to the right of the decimal separator. For example, Format(1234567, "Fixed") returns 1234567.00. |
|
Standard |
Displays number with thousand separator, at least one digit to the left and two digits to the right of the decimal separator. For example, Format(1234567, "Standard") returns 1,234,567.00. |
|
Percent |
Displays number multiplied by 100 with a percent sign (%) appended immediately to the right; always displays two digits to the right of the decimal separator. For example, Format(0.4744, "Percent") returns 47.44%. |
|
Scientific |
Uses standard scientific notation, providing two significant digits. For example, Format(1234567, "Scientific") returns 1.23E+06. |
|
Yes/No |
Displays No if number is 0; otherwise, displays Yes. For example, Format(0, "Yes/No") returns No. |
|
True/False |
Displays False if number is 0; otherwise, displays True. For example, Format(1, "True/False") returns True. |
|
On/Off |
Displays Off if number is 0; otherwise, displays On. For example, Format(1, "On/Off") returns On. |
Numeric Functions
| Function | Output | Syntax |
| Int | Converts the specified object to an Integer value. | Int( Object ) |
| Dec | Converts the specified object to a floating point decimal value. | Dec( Object ) |
| Rnd | A random number. | Rnd() |
| Round | A double precision floating-point value to the nearest integral value. | Round( Value ) |
| Abs | Unsigned absolute value of the specified object. | Abs( Value ) |
| Mod | The remainder after division of the two numbers. | Mod( Number1, Number2 ) |
| Min | Minimum of all the specified numbers. | Min( Number1, Number2, [...] ) |
| Max | Maximum of all the specified numbers. | Max( Number1, Number2, [...] ) |
| Money | Currency format of the specified value. | Money( Value ) |
Date Functions
| Function | Output | Syntax |
| Today | Date value containing the current date. | Today() |
| Now | Date value containing the current date and time. | Now() |
| Date | Date value created from the specified year, month and day. | Date( Year, Month, Day ) |
| Year | Year component of the specified date. | Year( Date ) |
| Month | Month component of the specified date. | Month( Date ) |
| Day | Day of the month represented by the specified date. | Day( Date ) |
| WeekDay | Day of the week represented by the specified date. | WeekDay( Date ) |
| Long_date | Long date string of the specified date (eg: 1st January 2016). | Long_date( Date ) |
| Format_date | Formatted date string of the specified date as per the specified format string. | Format_date( Date, Format* ) |
*Format argument for the Format_date function may be set as one or combination of:
|
Format |
Description |
|
w |
Displays day of the week, i.e., "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday". For example, Format_date( Date, "w" ) |
|
x |
Displays the short form of the day of the week, i.e., "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat" For example, Format_date( Date, "x" ) |
|
d |
Displays the day of the month with two chars as "st", "nd", "rd" or "th" as per the day value. For example, Format_date( "1/1/2016", "d" ) returns 1st. |
|
e |
Displays the day of the month. For example, Format_date( "1/1/2016", "e" ) returns 1. |
|
f |
Displays the day of the month in two digits format. For example, Format_date( "1/1/2016", "f" ) returns 01. |
|
m |
Displays the month of the year, i.e., "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December". For example, Format_date( "1/1/2016", "m" ) returns January. |
|
n |
Displays the month of the year in digit format. For example, Format_date( "1/1/2016", "n" ) returns 1. |
|
o |
Displays the month of the year in two digits format. For example, Format_date( "1/1/2016", "o" ) returns 01. |
|
p |
Displays short form of the month of the year, i.e., "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec". For example, Format_date( "1/1/2016", "m" ) returns Jan. |
|
y |
Displays the year component of the date. For example, Format_date( "1/1/2016", "y" ) returns 2016. |
|
z |
Displays the year component of the date in two digits format. For example, Format_date( "1/1/2016", "z" ) returns 16. |
|
d m y |
A combination of day month and year. For example, Format_date( "1/1/2016", "d m y" ) returns 1st January 2016. |
User Functions
| Function | Output | Syntax |
| UserEmail | Email address of the selected user. | UserEmail( USERS_FIELD ) |
| UserCellPhone | Cell phone number of the selected user. | UserCellPhone( USERS_FIELD ) |
| UserHomePhone | Home phone number of the selected user. | UserHomePhone( USERS_FIELD ) |
| UserWorkPhone | Work phone number of the selected user. | UserWorkPhone( USERS_FIELD ) |
Here, USERS_FIELD is the field name of a Users type field. For the above four system functions the supported function argument can be a field of type Assignee or Users.
Math Functions
| Function | Output | Syntax |
| Sqrt | Square root of the specified number. | Sqrt( Number ) |
| Power | Specified number raised to the specified power. | Power( Number1, Number2 ) |
| Pi | The constant value of the ratio of the circumference of a circle to its diameter. | Pi() |
| Sin | The sine of the specified value. | Sin( Value ) |
| Cos | The cosine of the specified value. | Cos( Value ) |
Have Questions?
If you have further questions, please feel free to contact us and we will be happy to assist you.
0 Comments