Formula Editor
The Formula Editor in Workmaster is a no-code tool that allows you to create, edit, and manage formulas visually or through direct text input. It helps you build formulas with numbers, text, conditionals, functions, and variables, providing both a guided menu and keyboard editing support.
The Menu Button
At the top left of the Formula Editor is the Menu button (three horizontal bars). Clicking this opens a menu of options:
Insert – Add functions, numbers, or text into your formula.
Edit – Modify the formula directly.
When the editor is empty, this menu shows only basic options (e.g., insert a number, text, or function). Once something is added, additional editing operations appear, such as:
Add Text Before – Lets you insert additional text, numbers, or functions before the selected element in your formula.
Add Text After – Works in the same way, but appends the chosen content after the selected element.
Replace – Allows you to swap the current element with another value, text, or function without removing the entire formula.
*Arithmetic Operators (+, –, , /) – Provides quick access to basic mathematical operations, enabling you to combine or calculate values inside your formula.
Edit – Opens the selected formula element in an inline editor, allowing you to make direct changes without replacing it.
Delete – Removes the selected element or function from the formula.
Show More Parameters – For functions that can accept multiple inputs, this option expands the formula so you can add additional (optional) parameters beyond the default ones provided.
Direct Editing
You can edit formulas directly in the text area of the editor:
Double-clicking on the formula area enables inline editing.
You can type formulas just like in a spreadsheet or programming language.
Both functions and variables support auto-complete as you type.
Entering a Text
Text (strings) must be enclosed in double quotes.
Example
"Hello Workmaster"
Entering a Number
Numbers can be typed directly without quotes.
Example
42
Auto-Complete
The Formula Editor supports auto-complete for both functions and variables:
Formula Names When you start typing a function name (e.g.,
STRINGTO), a dropdown will suggestSTRINGTOUPPERCASE. Pressing Tab auto-completes it.
Variable Names When typing variable names, suggestions appear based on available variables in the context. Selecting one auto-completes the name.
This feature reduces typing errors and speeds up formula creation.
Validating Formula
At the bottom-right of the Formula Editor, you will find the Play button (represented by a small play icon). This option allows you to validate the formula you have written. By clicking the play icon, the editor evaluates the formula and displays the result immediately.
The output includes:
The calculated value of the formula
The data type of the result (for example, string, number, or Boolean)
If the formula is invalid, the editor will instead display an error message, helping you quickly identify and correct mistakes before applying the formula in your app.
This validation step ensures your formulas are correct and working as expected, making it easier to test changes without needing to run the full application.
Last updated