Formulas
Terms
You can manually type in the cell or command bar, or you can select an option from the autofill dropdown.
Numbers
All numbers are available. To generate valid geometry, some fields have preferred, or minimum/maximum allowed values.
Preset Formulas
Presets are auto-calculated and cannot be used together with Functions, Numbers, Operators, etc. (e.g., AUTO+Diameter-20). Presets can vary depending on the field.
Field Names
All the fields from the geometry table will be available with the following exceptions:
The "Product Entry” field, which does not support formulas or being included in calculations.
The field currently being edited.
Fields that create circular dependencies.
Fields with the “Editable while detailing” option enabled.
If the fields contain special characters (!, @, #, $, etc.), emojis, or operators (^, *, /, etc.) isolate the term between quotation marks in the following format:“fieldname”.
Functions
Function names are displayed in the dropdown using capital letters.
| Function Name | Description |
|---|---|
| ABS | Absolute value of a number. |
| ARCCOS | Inverse cosine of a value, in radians. |
| ARCSIN | Inverse sine of a value, in radians. |
| ARCTAN | Inverse tangent of a value, in radians. |
| COS | Cosine of an angle provided in radians. |
| DEGREES | Converts an angle value in radians to degrees. |
| HYPOTENUSE | The longest side of a right-angled triangle. |
| MAX | Maximum value in a numeric dataset. |
| MIN | Minimum value in a numeric dataset. |
| PI | The number pi. |
| RADIANS | Converts an angle value in degrees to radians. |
| SIN | Sin of an angle provided in radians. |
| SQRT | Positive square root of a positive number. |
| TAN | Tangent of an angle provided in radians. |
Operators
| Operator Name | Description |
|---|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| ^ | Exponents |
| ( | Bracket Left |
| ) | Bracket Right |
Color Coding
The color scheme should reflect the applied theme.
| Data Type | Color |
|---|---|
| Keywords (Search terms) | Black |
| Valid Fields | Blue |
| Presets | Green |
| Numbers | Green |
| Functions | Green |
| Operators & Brackets | Black |
| Errors | Red (dotted underline) |