Formula List

XcheckStudio utlises several methods to support the search and interaction with datasets and dataset objects. These. methods also powers the setup of rules for validations such as data matching, duplication, identification, compliance, comparison and requirement checks etc.

To further augment these capabilities, we have developed XFL (XcheckStudio Formula Language), which supports advanced data pattern recognition and extractions.

Below are a list of functions and expressions which you can use on its own, or as a foundation for the construction of elaborate formulas.

Do note that everywhere we mention 'Search String' or 'String Value', these could be represented by: Constant e.g. "Any character", or Property value e.g. !!Property!!, or Conditional Expression e.g. Hasvalue(!!Name!!), Base Expressions e.g. Subs(!!Name!!, "2", "4")

As we continue to optimise our formula capabilities hence updating our formula list, do let us know if you would like us to include a formula or an expression which could better support your interaction with data.

Base Expressions

These expressions and functions can be used within product functions which requires the input of formulas and expressions. They can be used to return values or support conditions requiring a string input.
(Do note that when extracting values from ‘Reference properties’ within functions such as ‘Of’, ‘Created on’ and ‘Created by’, the reference properties are encapsulated by double quotes and not ‘!!’ as is used with other object properties).

After

After(Search string, Search character)
Scans the 'Search string', and returns all characters which occurs after the 'Search character'
Example: After(!!Name!!, "/") -> Returns 'P101' (If 'Search String' = /P101)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search Character': The character which is searched for, so that all characters positioned after it is collected.
Output
- Outputs all characters which occurs after the 'Search character'.

Before

Before(Search string, Search character)
Scans the 'Search string', and returns all characters which occurs before the 'Search character'
Example: Before(!!Name!!, "101") -> Returns '/P' (If 'Search String' = /P101)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula
- 'Search Character': The character which is searched for, so that all characters positioned before it is collected.
Output
- Outputs all characters which occurs before the 'Search character'.

Concatenation

Concat('String', 'String')
Combines multiple comma separated string values and characters to form a whole value of its own
Example: Concat("/", !!Name!!, "-E") -> Returns '/P101-E' (If 'Name' String = P101)
Input
- ' String': The value to be combined. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs a whole value from the combination of string values entered in the formula.

Created On

Createdon(Reference property)
Scans the indicated reference properties of applicable dataset objects and extracts the creation dates of the referenced objects.
Example: Createdon("FloorRef") -> Returns the creation date of the referenced object
Input
- 'Reference Property': The reference property where the search is performed (Double quotes are used here to encapsulate the reference property).
Output: Outputs the date the referenced object was created (Added to its database).

Created By

Createdby(Reference property)
Scans the indicated reference properties of applicable dataset objects and extracts the site member who created the referenced objects.
Example: Createdby("FloorRef") -> Returns the name of the site member that created the referenced object
Input
- 'Reference Property': The reference property where the search is performed (Double quotes are used here to encapsulate the reference property).
Output: Outputs the name of the site member that created the referenced object (Added to its database).

Format

Format("{0}-{1}-{2}-abc", String, String, String)
Extracts the values from the 'String' arguments, and places sequentially within the parameters (in curly bracket), to return a complete value matching the format structure.
Example: Format("{0}-{1}-abc", "Pump", !!Name!!) -> Returns 'Pump-/P101-abc' (Where '!!Name' derives /P101)
Input
- 'String': The argument where values are extracted from. This could be a property value, a constant or derived from a nested formula.
- 'Parameters {}': The placeholder for values extracted from the arguments. This must start with the number '0' to hold the first extracted value.
Output
- Outputs all value which substitutes the parameters with extracted string values and matches the structure of format.

Left

Left(Search string, number of characters)
Scans the 'Search string', and returns the required number of starting characters from the left
Example: Left(!!Name!!, "3") -> Returns '/P1' (If 'Search String' = /P101 and the 'Numberof characters' = 3)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Number of Characters': Specifies the number of characters to be returned from the search string value when counting from the left.
Output
- Outputs the specified number of characters from the value of the search string when counting from the first value.

Length

Length(Search string)
Scans the 'Search string' against applicable dataset objects and counts number of characters from the search string.
Example: Length(!!Name!!) -> Returns '5' (If 'Search String' = /P101 )
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a a count of all the characters from the returned value.

Lower

Lower(Search string)
Scans the 'Search string', and converts all returned texts to lower case
Example: Lower(!!Name!!) -> Returns 'abc' (If 'Search String' = ABC)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs all texts from the search string value in lower case.

Of(Search string, Reference Property)
Scans the item referenced in a 'Reference Property', and returns the value of the indicated referenced item's property.
Example: Of("Floor", "FloorRef") -> Returns 'Basement' (If the 'Reference Property' (FloorRef) = 'MyBuilding', and the 'Search string' 'Property which belongs to the referenced item' (Floor) = 'Basement')
Input
- 'Reference Property': The reference property. This could be a referenced data object, dataset, checknote etc.
- 'Search String': The property of the referenced item.
Output
- Outputs the value from the indicated property which belongs to the referenced item.

Right

Right(Search string, number of characters)
Scans the 'Search string', and returns the required number of starting characters from the right
Example: Right(!!Name!!, "3") -> Returns '101' (If 'Search String' = /P101 and the 'Numberof characters' = 3)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- ' Number of Characters': Specifies the number of characters to be returned from the search string value when counting from the right.
Output
- Outputs the specified number of characters from the value of the search string when counting from the last value.

Round down

Rounddown(Search string)
Scans the 'Search string' for numerical values with decimal places, and rounds down the value
Example: Rounddown(!!Name!!) -> Returns '58' (If 'Search String' = 58.892)
Input
- 'Search String': The value on which the rounddown is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs numerical values rounded down.

Replace

Replace(Search string, Search value, Replacement)
Scans the 'Search string' within the dataset for the search value/characters, and then replaces the search value with the replacement values/characters
Example: Replace(!!Name!!, "P", "E") -> Returns 'E101' (If 'Search String' = /P101, and 'Search value' = 'P', and 'Replacement' = 'E')
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value or character being searched for, which will be replaced by the 'Replacement' value/character.
- 'Replacement': The value or characters which replaces the value searched for.
Output
- Outputs the values from the 'Search String' where Searched for entries have been replaced by the Replacement characters .

Round up

Rounddown(Search string)
Scans the 'Search string' for numerical values with decimal places, and rounds up the value
Example: Roundup(!!Name!!) -> Returns '59' (If 'Search String' = 58.892)
Input
- 'Search String': The value on which the roundup is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs numerical values rounded up.

Substring

Subs(Search string, Start position, number of characters)
Scans the 'Search string', and extracts the specified number of characters starting from the 'Start poistion'
Example: Subs(!!Name!!, "2", "4") -> Returns 'P101' (If 'Search String' = /P101)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Start position': The character at the specified position in search string value
- 'Number of Characters': The number of characters to be returned counting from the start position.
Output:
- Outputs a number of characters from the search string, when the count is started from the character at the specified start position.

Trim

Trim(Search string)
Scans the 'Search string', and removes any trailing or leading white spaces after the string value.
Example: Trim(!!Name!!) -> Returns 'P101' (If 'Search String' = ' /P101')
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs the search string value without any leading or trailing white spaces.

Upper

Upper(Search string)
Scans the 'Search string', and converts all returned texts to upper case
Example: Upper(!!Name!!) -> Returns 'ABC' (If 'Search String' = abc)
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs all texts from the search string value in upper case.

Conditional expressions

Expressions and functions which returns boolean 'true' or 'False' results and are best used within a nested function or another expression.

And

And(Search string, Search string, Search string)
Scans the ' Search strings', and returns 'True' if all of the search strings evaluates to true.
Example: (And(Eq(!!Name!!, “E1301”), EQ(!!TYPE!!, “EQUI”), NotEQ(!!BUIL!!, “False”) -> Returns 'True' (If all of the comma separated conditional expression returns a 'True'
Input
- 'Search String': This is a conditional expression, which could be a nested expression.
Output
- Outputs a 'True' or 'False' result.

Contains

Contains(Search string, Search value)
Scans a dataset to find objects whose 'Search string' value contains the input values or expressions and returns all items that fulfills the condition.
Example: Contains(!!Name!!, "P104") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which should be contained within the 'String Search'.
Output: Outputs a 'true' or 'false' result.

Date Greater than

DateGt(!!Date Property!!, String value)
Scans a dataset to identify applicable objects whose indicated data property occurs later than the string value date.
Example: DateGt(!!Approved-on Date!!, "17th Jan 2026") -> Returns 'True' if !!Approved-on Date!! = '19th Jan 2026'
Input
- '!!Date Property!!': The date property with whose value the search is performed.
- 'String value': The date value which is checked against. This should be a date property, a constant or derived from a nested formula, encapsulated by double quotes.
Output: Outputs a 'True' or 'False' result.

Date Greater than or equal to

DateGtoreq(!!Date Property!!, String value)
Scans a dataset to identify applicable objects whose indicated data property occurs later than the string value date.
Example: DateGtoreq(!!Approved-on Date!!, "17th Jan 2026") -> Returns 'True' if !!Approved-on Date!! = '17th Jan 2026' or '19th Jan 2026'
Input
- '!!Date Property!!': The date property with whose value the search is performed.
- 'String value': The date value which is checked against. This should be a date property, a constant or derived from a nested formula, encapsulated by double quotes.
Output: Outputs a 'True' or 'False' result.

Date Less than

DateLt(!!Date Property!!, String value)
Scans a dataset to identify applicable objects whose indicated data property occurs earlier than the string value date.
Example: DateLt(!!Approved-on Date!!, "17th Jan 2026") -> Returns 'True' if !!Approved-on Date!! = '15th Jan 2026'
Input
- '!!Date Property!!': The date property with whose value the search is performed.
- 'String value': The date value which is checked against. This should be a date property, a constant or derived from a nested formula, encapsulated by double quotes.
Output: Outputs a 'True' or 'False' result.

Date Less than or equal to

DateLtoreq(!!Date Property!!, String value)
Scans a dataset to identify applicable objects whose indicated data property occurs earlier or at the same time as the string value date.
Example: DateLtoreq(!!Approved-on Date!!, "17th Jan 2026") -> Returns 'True' if !!Approved-on Date!! = '15th Jan 2026' or '17th Jan 2026'
Input
- '!!Date Property!!': The date property with whose value the search is performed.
- 'String value': The date value which is checked against. This should be a date property, a constant or derived from a nested formula, encapsulated by double quotes.
Output: Outputs a 'True' or 'False' result.

Does not Contain

Doesnotcontain(Search string, Search value)
Scans a dataset to find objects whose 'Search string' value does not contain the input values or expressions and returns all items that fulfills the condition.
Example: Doesnotcontain(!!Name!!, "P104") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which should not be contained within the 'String Search'.
Output: Outputs a 'true' or 'false' result.

Ends with

Endswith(Search string, Search value)
Scans a dataset to find objects whose 'Search string' has a value that ends that ends with the input values or expressions and returns all items that fulfills the condition.
Example: Endswith(!!Name!!, "04") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for, which the 'String Search' should end with.
Output: Outputs a 'true' or 'false' result

Equal

Eq(Search string, Search value)
Scans a dataset to find objects whose 'Search string' value is equal to the input values or expressions and returns all items that fulfills the condition.
Example: Eq(!!Name!!, "P104") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which should equal the 'String Search'.
Output: Outputs a 'true' or 'false' result

Followssyntax

Followssyntax(Search string, Format syntax)
Scans a dataset to find objects whose 'Search string' value is formated according to the entered format syntax
Example: Followssyntax(!!Name!!, {/}LNNN) -> Returns 'True' or 'False' (For example this could return '/P101')
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- ' Format Syntax': The structure of the value. Where 'L = Letter', 'N = Number', '{} = escape character' .
Output: Outputs a 'true' or 'false' result

Greater Than

Gt(Search string, Search value)
Scans a dataset to find objects whose numeric 'Search string' value is greater than the input numeric input values or expressions and returns all items that fulfills the condition.
Example: Gt(!!Name!!, "104") -> Returns 'True' or 'False'
Input
- 'Search String': The numeric value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which the 'String Search' should be greater than.
Output: Outputs a 'true' or 'false' result.

Greater Than or Equal to

Gteq(Search string, Search value)
Scans a dataset to find objects whose numeric 'Search string' value is greater than the input numeric input values or expressions and returns all items that fulfills the condition.
Example: Gteq(!!Name!!, "104") -> Returns 'True' or 'False'
Input
- 'Search String': The numeric value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which the 'String Search' should be greater than or equal to.
Output: Outputs a 'true' or 'false' result.

Has Value

Hasvalue(Search string)
Scans a dataset to find objects whose 'Search string' value exists and is not empty, and returns all items that fulfills the condition.
Example: Hasvalue(!!Name!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Has no value

Hasnovalue(Search string)
Scans a dataset to find objects whose 'Search string' value does not exists and is empty, and returns all items that fulfills the condition.
Example: Hasnovalue(!!Name!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

If(Search string, iftrue, iffalse)
Evaluates the appropriate 'Search string' for a boolean (true / false) outcome, and returns an equivalent string value for either the 'True' or 'False' outcome
Example: If(HasValue(!!Name!!), "Name has value", "Name has no value") -> Returns 'Name has value' (If 'Search String' = /P101)
Input
- 'Search String': The string input where the conditional evaluation is performed. This could be an expression, or derived from a nested formula.
- ' iftrue': The outcome to be deployed if the search string evaluates to 'True'. This could be a property value, a constant or derived from a nested formula.
- 'iffalse': The outcome to be deployed if the search string evaluates to 'False'. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs all result values based on if the conditional search string evaluates to true or false. .

Is a part of

Isapartof(Search string, Search Value)
Scans a dataset to find objects whose 'Search string' value is a part of (Contained within ) the input search value or expression, and returns all items that fulfills the condition.
Example: Isapartof(!!Name!!, "ABCDE") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Is Even

IsEven(Search string)
Scans a dataset to find objects whose 'Search string' numerical value is an even number.
Example: Iseven(!!Number!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Is not a part of

Isnotapartof(Search string, Search Value)
Scans a dataset to find objects whose 'Search string' value is not a part of (Not contained within ) the input search value or expression, and returns all items that fulfills the condition.
Example: Isnotapartof(!!Name!!, "ABCDE") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Is not Null

Isnotnull(Search string)
Scans a dataset to find objects whose 'Search string' exists, and returns all items that fulfills the condition.
Example: Isnotnull(!!Name!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Is Null

Isnull(Search string)
Scans a dataset to find objects whose 'Search string' does not exist, and returns all items that fulfills the condition.
Example: Isnull(!!Name!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Is Odd

Isodd(Search string)
Scans a dataset to find objects whose 'Search string' numerical value is an odd number.
Example: Isodd(!!Number!!) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
Output: Outputs a 'true' or 'false' result.

Less Than

Lt(Search string, Search value)
Scans a dataset to find objects whose numeric 'Search string' value is less than the input numeric input values or expressions and returns all items that fulfills the condition.
Example: Lt(!!Name!!, "104") -> Returns 'True' or 'False'
Input
- 'Search String': The numeric value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which the 'String Search' should be less than.
Output: Outputs a 'true' or 'false' result.

Less Than or Equal to

Lteq(Search string, Search value)
Scans a dataset to find objects whose numeric 'Search string' value is less than or equal to the input numeric input values or expressions and returns all items that fulfills the condition.
Example: Lteq(!!Name!!, "104") -> Returns 'True' or 'False'
Input
- 'Search String': The numeric value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which the 'String Search' should be less than or equal to.
Output: Outputs a 'true' or 'false' result.

Not

Not(Search string)
Scans a dataset to find objects whose 'Search string' value is a boolean, and it negates that result to return all items that fulfills the condition. If its nested expression evaluates to 'true', the final result will be returned as 'False', and vice versa.
Example: Not(Eq(!!Name!!, "P104")) -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a boolean property value, or derived from a nested formula and its result will be negated.
Output: Outputs a 'true' or 'false' result.

Not Equal

Noteq(Search string, Search value)
Scans a dataset to find objects whose 'Search string' value is not equal to the input values or expressions and returns all items that fulfills the condition.
Example: Eq(!!Name!!, "P104") -> Returns 'True' or 'False'
Input
- 'Search String': The value where the search is performed. This could be a property value, a constant or derived from a nested formula.
- 'Search value': The value being searched for which should not be equal the 'String Search'.
Output: Outputs a 'true' or 'false' result.

Or(Search string, Search string, Search string)
Scans the 'Search strings', and returns 'True' if any one of the search strings evaluates to true.
Example: Or(Eq(!!Name!!, “E1301”), EQ(!!TYPE!!, “EQUI”), NotEQ(!!BUIL!!, “False”) -> Returns 'True' (If any of the comma separated conditional expression returns a 'True'
Input
- 'Search String': This is a conditional expression, which could be a nested expression.
Output
- Outputs a 'True' or 'False' result.

Conditional selections

These conditions and expressions are provided by default within product template/configuration nodes that require them. They contained within a 'conditions' picklist control. E.g. Rule groups node, property mappings, register rules definition, data groups (Custom) definition, global search settings e.t.c. They can return boolean ('True' / 'False') results or can be used together with a formula / expression as a string input.

Contains

Contains
Scans a dataset, to find objects whose 'Search string' (a selected property) values contains the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Contains(Picklist) -> "P"(Expression input) -> '/P101' (If 'Search String' = /P101)
Output
- Returns objects from a target dataset whose search string property value contains the search input.

Does not contain

Does not Contain
Scans a dataset, to find objects whose 'Search string' (a selected property) values does not contain the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Does not Contain(Picklist) -> "P"(Expression input) -> '/E101' (If 'Search String' = /E101)
Output
- Returns objects from a target dataset whose search string property value does not contain the search input.

Does not end with

Does not end with
Scans a dataset, to find objects whose 'Search string' (a selected property) values does not end with the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Does not end with(Picklist) -> "P"(Expression input)' (If '' = /E101)
Output
- Returns objects from a target dataset whose search string property value does not end with the search input.

Does not start with

Does not start with
Scans a dataset, to find objects whose 'Search string' (a selected property) values does not start with the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Does not start with(Picklist) -> "/P"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value does not start with the search input.

Ends with

Ends with
Scans a dataset, to find objects whose 'Search string' (a selected property) values ends with the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Ends with(Picklist) -> "/P"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value ends with the search input.

Equal to

Equal to
Scans a dataset, to find objects whose 'Search string' (a selected property) values is equal to the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Equal to(Picklist) -> "/P"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value is equal to the search input.

Follows the syntax

Follows the syntax
Scans a dataset, to find objects whose 'Search string' (a selected property) values follows the syntax structure input , and returns all items that fulfills the condition. Here, 'L' = Letter, 'N' = Number, {} = used to escape the syntax structure.
Example: Name(Picklist) -> Follows the syntax(Picklist) -> {/}LNNN(Expression input) -> If True, returns objects whose property values follows the specified syntax(e.g '/P101'). Returns nothing if no object's property value follows the syntax.‍
Output
- Returns objects from a target dataset whose search string property value matches the input syntax structure.

Has no value

Has no value
Scans a dataset, to find objects whose 'Search string' (a selected property) has no value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Has no value(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property has no value.

Has value

Has value
Scans a dataset, to find objects whose 'Search string' (a selected property) has value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Has value(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property has value.

Is a number

Is a number
Scans a dataset, to find objects whose 'Search string' (a selected property) has numerical characters only as its value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is a number(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property has numerical characters only as its value.

Is a part of

Is a part of
Scans a dataset, to find objects whose 'Search string' (a selected property) values is contained in its wholeness to the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is a part of(Picklist) -> "ABC/P101EF"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value is wholly contained within the search input.

Is a text

Is a text
Scans a dataset, to find objects whose 'Search string' (a selected property) has text characters only as its value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is a text(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property has text characters only as its value.

Is greater than

Is greater than
Scans a dataset, to find objects whose 'Search string' (a selected numerical property) values is greater than the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is greater than(Picklist) -> "100"(Expression input)‍
Output
- Returns objects from a target dataset whose search string numerical property value is greater than the numerical search input.

Is greater than or equal to

Is greater than or equal to
Scans a dataset, to find objects whose 'Search string' (a selected numerical property) values is greater than or equal to the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is greater than or equal to(Picklist) -> "100"(Expression input)‍
Output
- Returns objects from a target dataset whose search string numerical property value is greater than or equal to the numerical search input.

Is in between

Is in between
Scans a dataset, to find objects whose 'Search string' (a selected numerical property) values is positioned in between the input values or expression (Separated by the 'AND' operand), and returns all items that fulfills the condition.
Example: Number(Picklist) -> Is in between(Picklist) -> "AND("99", "110") (Expression input) If Number property value = '101'‍
Output
- Returns objects from a target dataset whose search string numerical property value is in between the numerical search inputs.

Is less than

Is less than
Scans a dataset, to find objects whose 'Search string' (a selected numerical property) values is less than the input values or expression, and returns all items that fulfills the condition.
Example: Number(Picklist) -> Is less than(Picklist) -> "100"(Expression input)‍
Output
- Returns objects from a target dataset whose search string numerical property value is less than the numerical search input.

Is less than or Equal to

Is less than or Equal to
Scans a dataset, to find objects whose 'Search string' (a selected numerical property) values is less than or equal to the input values or expression, and returns all items that fulfills the condition.
Example: Number(Picklist) -> Is less than or equal to (Picklist) -> "100"(Expression input)‍
Output
- Returns objects from a target dataset whose search string numerical property value is less than or equal to the numerical search input.

Is not a number

Is not a number
Scans a dataset, to find objects whose 'Search string' (a selected property) does not have numerical characters only as its value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is not a number(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property does not have numerical characters only as its value.

Is not a part of

Is not a part of
Scans a dataset, to find objects whose 'Search string' (a selected property) values is not contained in its wholeness to the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is not a part of(Picklist) -> "ABC/P101EF"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value is not wholly contained within the search input.

Is not a text

Is not a text
Scans a dataset, to find objects whose 'Search string' (a selected property) does not have text characters only as its value, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is not a text(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property does not have text characters only as its value.

Is not equal to

Is not Equal to
Scans a dataset, to find objects whose 'Search string' (a selected property) values is not equal to the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is not Equal to(Picklist) -> "/P"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value is not equal to the search input.

Is null

Is null
Scans a dataset, to find objects whose 'Search string' (a selected property) does not exist against the object, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is null(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property does not exist.

Not null

Not null
Scans a dataset, to find objects whose 'Search string' (a selected property) exists against the object, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Is not null(Picklist) -> Returns 'True' or 'False'‍
Output
- Returns objects from a target dataset whose search string property exists.

Starts with

Starts with
Scans a dataset, to find objects whose 'Search string' (a selected property) values starts with the input values or expression, and returns all items that fulfills the condition.
Example: Name(Picklist) -> Starts with(Picklist) -> "/P"(Expression input)‍
Output
- Returns objects from a target dataset whose search string property value starts with the search input.

Constants expressions

Date and time expressions

Expressions and functions to aid the extraction and manipulation of date and time values.
(Do note that when extracting values from any date type properties or from reference properties, these properties are encapsulated by double quotes and not ‘!!’ as is used with other object properties).

Date Subtraction

Datesubt(''Date Property'', String value)
Scans a dataset and subtracts the string value from the date property value of applicable objects to give an updated date value.
Example: Datesubt(''Approved-on Date'', "2") -> Returns '13th Jan 2026' if ''Approved-on Date'' = '15th Jan 2026'
Input
- '''Date Property''': The date property with whose value the search is performed.
- 'String value': The numerical value which is subtracted from the date property. This could be a property value, a constant or derived from a nested formula.
Output: Outputs the day number the date property carries.

Date Sum

Datesum(''Date Property'', String value)
Scans a dataset and adds the date property value of applicable objects to the string value to give an updated date value.
Example: Datesum(''Approved-on Date'', "2") -> Returns '17th Jan 2026' if ''Approved-on Date'' = '15th Jan 2026'
Input
- '''Date Property''': The date property with whose value the search is performed.
- 'String value': The numerical value which is added to the date property. This could be a property value, a constant or derived from a nested formula.
Output: Outputs the day number the date property carries.

Day

Day(''Date Property'')
Scans a dataset and returns the day number of the date property value of applicable objects.
Example: Day(''Approved-on Date'') -> Returns the day number
Input
- '''Date Property''': The date property with whose value the search is performed.
Output: Outputs the day number the date property carries.

Day Name

Dayname(''Date Property'')
Scans a dataset and returns the day name of the date property value of applicable objects.
Example: Dayname(''Approved-on Date'') -> Returns the day name
Input
- '''''Date Property''': The date property with whose value the search is performed.
Output: Outputs the day name the date property carries.

Hour

Hour(''Date Property'')
Scans a dataset and returns the hour of the date property 'Search string' values of applicable objects.
Example: Hour(''Approved-on Date'') -> Returns a date value (hour)
Input
- 'Search String': The date property with whose value the search is performed.
Output: Outputs the hour the date property carries.

Month

Month(''Date Property'')
Scans a dataset and returns the month number of the date property 'Search string' value of applicable objects.
Example: Month(''Approved-on Date'') -> Returns a date value (month number)
Input
- 'Search String': The date property with whose value the search is performed.
Output: Outputs the month number the date property carries.

Month Name

Monthname(''Date Property'')
Scans a dataset and returns the month name of the date property 'Search string' value of applicable objects.
Example: Monthname(''Approved-on Date'') -> Returns a date value (month name)
Input
- 'Search String': The date property with whose value the search is performed.
Output: Outputs the month name the date property carries.

Now

Now()
This simply returns the current date and time (Year, month, day, hour, minute, seconds)
Example: GT(''Date Property'', Now) -> Returns 'True' or 'False'
Input
- ' Now': The current date and time (includes the hour, minute and seconds) when the formula is excuted. Running the 'Update calculated property' control will update this date to the latest date and time.
Output: Outputs the latest date and time (including the hour, minute and seconds) when first added, and will always return the latest date and time with each 'Update calculated property' action.

Today

Today()
This simply returns the current date and time (Year, month, day)
Example: GT(''Date Property'', Today) -> Returns 'True' or 'False'
Input
- ' Today': The current date and time (Without the hour, minutes and seconds) when the formula is excuted. Running the 'Update calculated property' control will update this date to the latest date and time.
Output: Outputs the latest date and time (Without the hour, minutes and seconds) when first added, and will always return the latest date and time with each 'Update calculated property' action.

Week

Week(''Date Property'')
Scans a dataset and returns the week number of the date property 'Search string' value of applicable objects.
Example: Week(''Approved-on Date'') -> Returns the week number
Input
- 'Search String': The date property with whose value the search is performed.
Output: Outputs the week number the date property carries.

Year

Year(''Date Property'')
Scans a dataset and returns the year of the date property 'Search string' value of applicable objects.
Example: Year(''Approved-on Date'') -> Returns the year value
Input
- 'Search String': The date property with whose value the search is performed.
Output: Outputs the year the date property carries.

Math expressions

Mathematical operations utilised as input functions or expressions

Addition

Sum(Search string, Search string)
Scans the numerical 'Search string', and performs the addtion operation on input values
Example: Sum(!!number!!, "10") -> Returns '110' (If 'Search Strings' = '100' and '10')
Input
- 'Search String': The numerical values with which the operation is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs the sum value of all input numerical search string.

Division

Div(Search string, Search string)
Scans the numerical 'Search string', and performs the division operation on input values
Example: Div(!!number!!, "10") -> Returns '10' (If 'Search Strings' = '100' and '10')
Input
- 'Search String': The numerical values with which the operation is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs the quotient value from the division of all input numerical search strings.

Max

Max(Search string, Search string, Search string)
Scans a dataset to find objects with the indicated numerical 'Search string' values and returns the maximum value.
Example: Max(!!Length1!!, !!Length2!!, !!Length3!!) -> Returns the maximum value from the array of numerical strings.
Input
- 'Search String': The numerical value where the search is performed. This could be a boolean property value, a constant or derived from a nested formula.
Output: Returns the maximum (largest) value from the collected numerical string values.

Min

Min(Search string, Search string, Search string)
Scans a dataset to find objects with the indicated numerical 'Search string' values and returns the minimum value.
Example: Min(!!Length1!!, !!Length2!!, !!Length3!!) -> Returns the minimum value from the array of numerical strings.
Input
- 'Search String': The numerical value where the search is performed. This could be a boolean property value, a constant or derived from a nested formula.
Output: Returns the minimum (smallest) value from the collected numerical string values.

Product

Prod(Search string, Search string)
Scans the numerical 'Search string', and performs the multiplication operation of input values
Example: Prod(!!number!!, "10") -> Returns '1000' (If 'Search Strings' = '100' and '10')
Input
- 'Search String': The numerical values with which the operation is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs the product value of all input numerical search strings.

Subtraction

Subt(Search string, Search string)
Scans the numerical 'Search string', and performs the subtraction operation on input values
Example: Subt(!!number!!, "10") -> Returns '90' (If 'Search String' = '100' and '10')
Input
- 'Search String': The numerical values with which the operation is performed. This could be a property value, a constant or derived from a nested formula.
Output
- Outputs the subtraction value of all input numerical search string.

Object Properties

Regular Expressions