Formula field

CONCAT( , ) or &

Concatenate two values.

Example:

CONCAT("Hello ", {Fullname}, " !")

or

"Hello " & {Fullname} & " !"

 

IF (statement, Action A, Action B)

Check whether the statement is true. If it is true, then do action A, if it is false do action B.

Example:

IF({UserId}, "https://dashboard.com/" + {UserId}, "")

 

AND( )

Returns true if all the arguments are true, returns false otherwise.

Example:

AND({Field 1}),{Field 2})

or

{Field 1]AND{Field 2}

 

OR( )

Returns true id any one of the argument is true.

Example:

OR({Field 1}),{Field 2})

or

{Field 1]OR{Field 2}

 

NOT( )

Reverse a true to false.

Example:

NOT(a<b)=> Returns the same as a>=b

 

LEN

Returns the length of a string.

Example:

LEN("Hello World") =>11

 

REGEX_MATCH( )

Returns whether the input text matches a regular expression.

Example:

REGEX_MATCH("Good Morning","Good.Morning" =>True (Represented as a checked checkbox)

 

REGEX_REPLACE( )

Substitutes all matching substrings with a replacement string value.

Example:

REGEX_REPLACE("Good Morning","M*",""=>"Good"

 

REGEX_EXTRACT( )

Returns the first substring that matches a regular expression.

Example:

REGEX_EXTRACT("Good Morning","M*",""=>"Morning"

 

TRIM( )

Removes the whitespace at the beginning and end of string.

Example:

TRIM(" Hello ") =>"Hello"

 

UPPER( )

Makes string uppercase.

Example:

UPPER("Hello") =>"HELLO"

 

LOWER( )

Makes string lowercase.

Example:

LOWER("Hello") =>"hello"

 

RIGHT( )

Extract how many characters from the end of the string. Accepts string for first arg, number for second.

Example:

RIGHT("Hello",2) =>"lo"

 

IS_SAME( )

Compares two dates up to a unit and determines whether they are identical. Returns 1 is yes, 0 if no.

Example:

IS_SAME({date 1},{date 2}, 'unit' => current acceptable units are:

'exact'(matches all units)

'year', 'month','day'

 

IS_BEFORE

Determines if [date1] is earlier than [date2]. Returns 1 is yes, 0 if no.

Example:

IS_BEFORE({date 1},{date 2})

 

IS_AFTER( )

Determines if [date1] is later than [date2]. Returns 1 is yes, 0 if no.

Example:

IS_AFTER({date 1},{date 2})

 

YEAR( )

Returns the four-digit year of datetime.

Example:

YEAR({Date},[timezone])

 

MONTH( )

Returns the month of a datetime as a number between 1 (January) and 12 (Decemeber).

Example:

MONTH({Date},[timezone])

 

DAY( )

Returns the day of a month of a datetimein the form of a number between 1-31.

Example:

DAY({Date},[timezone])

 

HOUR( )

Returns the hour of a datetime as a number between 0 (12.00am) and 23 (11.00pm).

Example:

HOUR({Date},[timezone])

 

MINUTE( )

Returns the minute if datetime as a number.

Example:

MINUTE({Date},[timezone])

 

LEFT( )

Extract how many characters from the beginning of the string. Accepts the string for first arg, number for second.

Example:

LEFT("Hello",2) =>"He"

 

DATEDIF( )

Calculates the number of the specified periods between datetime values.

Example:

DATEDIF([date1],[date2],"units")

 

MIN( )

Returns the item with the lowest value, or the item with the lowest value in an iterable.

Example:

MIN(number 1, number 2, number 3...)

 

MAX( )

Returns the largest item in an iterable. It can also be used to find the largest item between two or more parameters.

Example:

MAX(number 1, number 2, number 3...)

 

ABS(number)

Returns the absolute value.

Example:

ABS(-5)

 

DATEADD( )

Adds a time/date interval to a date and then returns the date.

Example:

DATEADD([date],[#],"units") (accepts years, months, weeks and days as well as singular counter-parts)

 

TODAY(timezone)

Returns the current date, but not the current time.

 

NOW( )

Returns the current date and time.

 

TONOW( )

Returns the string of relative time to now.

 

ROUND( )

Rounds to a number of decimal places as specified by precision e.g "0", "1", etc.

Example:

ROUND({Unit Price},0)

 

ROUNDUP

Rounds the value to the number of decimal places given by "precision" always rounding up. e.g "0", "1", etc.

Example:

ROUNDUP({Unit Price},0)

 

VALUE(string)

Coverts text string to a number.

Example:

VALUE({Quoted Price})

 

INT()

Returns the greatest integer that is less than or equal to the number.

Example:

INT({Unit Price})