Functions

Functions in Workmaster are built-in operations that you can use inside formulas to perform calculations, manipulate text, work with dates, query data, and more. They provide ready-to-use logic so you don’t need to write code.

For example, a math function like:

AVERAGE(5, 10, 15)

returns 10, while a string function like:

STRINGTOUPPERCASE("workmaster")

returns WORKMASTER.

Functions can be combined with variables, conditionals, and page parameters, making them a powerful way to add intelligence and automation to your app.

Parameters in Functions

Every function comes with one or more parameters—the values you pass into it to control how it works. In the Formula Editor, parameters are color-coded for clarity:

Required Parameters (Red)

Parameters highlighted in red must be filled in for the function to work.

Example:

ROUND(number)

number is required.

Optional Parameters (Green)

Parameters highlighted in green can be left empty. They provide additional customization but are not mandatory.

To use optional parameters, click on menu button and select Show more parameters.

Example:

IF(condition to test, value if true, value if false)

The value if false parameter is optional.

Categories of Functions

Workmaster functions are organized into categories, making it easier to find the operation you need. Each category contains multiple functions designed for a specific type of task.

ApplicationData ListDateDropdownFormulaLogicalMathQueryStringUnknownUser

Last updated