Building Formulas
- 23 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Building Formulas
- Updated on 23 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Creation of Formulas occurs within the Formula Designer menu. Users can create, test, and save Formulas from here to use throughout the platform.
Formula Designer
1. Formulas require a name.
2. Input data is not required for Formulas but can be used to pull in data created within Flows.
3. The actual Formula is written in the Formula Builder box. It starts with a Function which can be selected from the Function list, or typed in manually. Functions will auto-populate as they are entered. Text within the writer has three different colors to indicate the property type.
| Color | Example | Description |
|---|---|---|
| Green |  | Function |
| Black |  | Constant |
| Purple |  | Variable |
Variables will require specific datatypes - variables of the Double type will not work if a letter is entered into them, for example. To determine what datatype is needed for a variable, pull the Function up in the FUNCTIONS tab and press the help icon.
This Function has two variables, both of which are String datatype.Also note that some Functions require another Function to work properly in a Formula. For instance, Functions that involve lists require either the makearray Function or have the Is List setting enabled for Input Data.
Input Data
Pressing the SHOW EDITOR button under Input Data will take the user to the Input Data screen. This menu looks and functions just like any other menu for creating datatypes within Decisions.
Because of its consistent use within Functions the default type is always Double. This can be changed to any out of the box type provided by Decisions, or to any custom datatype that has been created.
Any datatype available within a Project will appear on the drop down list.To make the data a List type, press the IS LIST box. This is important for getting certain Functions that require Lists to work properly. If a new data type needs to be made, press the Create Type action, just above the type selection field.
Was this article helpful?
