All Collections
Designers, controls, fields and editors
Expression editor
Using yeeflow predefined functions in expression editor
Using yeeflow predefined functions in expression editor

Easily leverage Yeeflow's predefined functions in the Expression Editor. Streamline data analysis and enhance customization effortlessly.

Updated over a week ago

Functions are are predefined formulas that can be used to perform simple or complex data calculations and logic validation etc.

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. A expression support multiple predefined functions. A function support multiple functions between it, called nested functions.

• Function Structure

• Nested functions

• Functions by Category

• String functions

• Logical functions

• Date functions

• Mathematical functions

## Function Structure

The structure of a function begins with the function name ①, followed by an opening parenthesis, the arguments ③ for the function separated by commas, and a closing parenthesis.

When you select any function name, you will see the instruction of how to use this function ②.

## ① Function Name

Yeeflow offer the available functions in listed based on your scenarios.

## ② Argument(s)

Arguments, or called parameters, can be numbers, strings, datetimes, logical values such as TRUE or FALSE, arrays, lookup references, or any applicable expressions. The argument you designate must produce a valid value for that argument. Arguments can also be constants, formulas, or other functions.

## ③ Formula Tooltip

A tooltip will appears as you select this function.

## Nested Functions

In certain cases, you may need to use a function as one of the arguments of another function. For example, the following formula uses a nested isNullOrEmpty function as an argument to return the value. The isNullOrEmpty is nested within the iif

function.

Please Note: When a nested function is used as an argument, the nested function must return the same type of value that the argument uses. For example, if the argument returns a TRUE or FALSE value, the nested function must return a TRUE or FALSE value. If the function doesn't, it displays an error value.

## Functions by Category

Functions are categorized by their functionality. Click a category header to quick browse its functions.

Based on scenarios, Yeeflow offers different functions under categories.

• ## String Functions

String functions perform various character manipulations. They operate on character strings. A string expression evaluates to a sequence of characters or text.

 Function Description Syntax Applied len Returns the number of characters in a text string or a numeric. len() All strIndex Searches an expression for another expression and returns its starting position if found. strIndex(, [, ]) All replace Replacing first occurrence of a specified string value with another string value. replace(,,) All subString Creates a new string starting from a fixed number of characters into the original string. subString(,,) All lower Converts text to lowercase. lower() All upper Converts text to uppercase. upper() All regExp Test Executes a search for a match between a regular expression and a specified string. Returns true or false. regExpTest(, ) All JSONParse Parses a JSON string, constructing the JavaScript value or object described by the string. JSONParse () Forms Variables & Rules & Conditions JSONStringfy Converts a JavaScript object or value to a JSON string. JSONStringfy (

• ## Logical Functions

Logical functions can create expressions that convert values from one to another.

 Function Description Syntax Applied iif Evaluates each WHEN condition and if satisfied, assigns the value in the corresponding THEN expression.If none of the WHEN conditions are satisfied, it assigns the default value specified in the ELSE expression. If no ELSE expression is specified, the system automatically adds an ELSE NULL. iif(, , ) All isNullOrEmpty Returns True if the specified String object is NULL or an empty string; otherwise, False is returned. isNullOrEmpty() All not Changes false to true, or true to false. not() Forms Variables & Rules & Conditions isTrue Determines if an expression is ture.The value of the expression is false in the following cases: null, empty string, string 'false', string of 'False', boolean false, otherwise is true isTrue() Forms Variables & Rules & Conditions isFalse Determines if an expression is false. isFalse() Forms Variables & Rules & Conditions

• ## Date Functions

Date functions conduct the data of DATE and DATETIME based on a calendar year.

 Function Description Syntax Applied datePicker Select the date and time. datePicker () All dateAdd Add or subtract the specified time interval from the date. dateAdd (, , ) All datePart Specifies the date of the specified date part datePart (, ) All dateDiff Specifies the number of time intervals between two dates. If date 1 refers to a later point in time than date 2, the dateDiff function returns a negative number. dateDiff (, , , ) All now Returns the current date and time. now () All dateFormat Format the current date and time:year: YYYYmonth: MMday: DDhours: HHminutes: mmseconds: ss dateFormat (, ) All

• ## Mathematical Functions

Mathematical functions perform mathematical operations on the data of NUMBER.

 Function Description Syntax Applied round Rounds a value to the nearest integer or to the specified number of fractional digits. round(, []) All

• ## Other Functions - Advanced functions

The other functions contain some advanced functions as:

• Lookup functions, such as "listLookup"

• System reference functions, such as "getUserAttr"

• Statistical functions, such as "arrayConcat”

• Engineer Functions. such as "getAttr"

It returns the values from your lookup source, system data, or some complex variables.

 Function Description Syntax Applied getUserAttr​ Retrieves user attribute. Attributes will be separated by comma if user expression is an array.​ getUserAttr(, , []) ​ All getOrgAttr​ Retrieves organization attribute. Attributes will be separated by comma if organization expression is an array.​ getOrgAttr(, , [])​ All getLocAttr​ Retrieves location attribute. Attributes will be separated by comma if location expression is an array.​ getLocAttr(, , []) ​ All arrIndex​ Locates the position of a value in array, return -1 if not exist.​ arrIndex(, )​ All arrayConcat​ Returns a new array that contains the elements of each of the given sequence of two arrays.​ arrayConcat (, )​ All listLookup​ Gets field value from data list.​ listLookup(, , , )​ Forms Variables & Rules & Conditions​ positionLookup ​ Finds user(s) by position.​ positionLookup (, , , [])​ Forms Variables & Rules & Conditions​ getAttr​ Returns the attribute value form an object by given.​ getAttr (