Formula

A formula is a structured expression used to calculate values, combine text, or apply logic dynamically inside your Workmaster application. Formulas let you add intelligence and automation to your app without writing code.

Example: Number Formula

1 + (2 - 0.5) / 3

This evaluates standard arithmetic and returns 1.5.

Example: Text (String) Formula

"Jack" & " " & "Jill"

Here, the & operator concatenates text values together, producing Jack Jill

---

Formula Functions

Functions extend formulas with built-in operations such as math, text manipulation, date handling, and more.

Example: Numeric Function

AVERAGE(5, 10, 15)

Returns the average of the given numbers: 10.

Example: String Function

STRINGTOUPPERCASE("workmaster")

Converts text to uppercase:

WORKMASTER

For a full list of all available formula functions, see: 👉 Functions

---

Variables in Formulas

Variables in Workmaster can be used inside formulas to represent values that change depending on user input, queries, or system context. They make formulas dynamic and adaptable.

Example

"Hello " &userName

If the variable userName contains Jack, the formula evaluates to:

Hello Jack

Example with Numbers

price * quantity

If price = 100 and quantity = 2, the formula evaluates to 200.

---

Page Parameters

Page parameters allow you to pass dynamic values into a page and use them directly inside formulas.

• Declaring a Page Parameter Suppose you declare a parameter named title for a page.

• Using the Page Parameter in a Formula

  "Welcome to " & title

  If the parameter title is set to "Dashboard", the formula result is:

  Welcome to Dashboard