Formula
- 18 Jun 2024
- 2 Minutes to read
- Print
- PDF
Formula
- Updated on 18 Jun 2024
- 2 Minutes to read
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
A formula is a mathematical expression, or an equation used to make calculations.
The Application Designer can configure the formula widget in the form designer to configure various formulas that can be used to make calculations such as Service Level Agreements (SLAs), managing workflows, etc.
To Formula widget under Design Form is displayed. 
Figure: Formula
User Persona: Application Designer
Let's explore the following use-case.
Use Case User Persona: Application Designer | Solution |
| ACME wants to configure different SLAs for different priorities of tickets, calculate costs for different materials and add multiple other calculations. They want to add a customized formula for calculating the SLAs. | To achieve this, the administrator can drag and drop the Formula widget to the Form Designer canvas and configure the widget. The administrator can mention the customized formulas as per the organizational needs. |
Configure Formula widget!
To configure the formula widget, perform the following steps:
- Navigate to Design Studio > Module. Click Form Designer and select the form to be configured.
- On the General Tab, enter all mandatory details required for the Form.
- Under the Design Form tab, select Widgets > Formula.
- Drag and drop this widget inside a panel to create a Formula field. Click Settings to configure Formula.
The Formula widget page is displayed:
Figure: Formula settings
On the settings page, the following tabs can be configured.
Properties
The list of Properties using which the Application Designer can configure the respective widget's label, and subtitles, which are mentioned.
To know more about the fields that are available under the Properties section, see Field Description.
Figure: Properties
Field Description
This table contains the list of fields and their descriptions that are available under the Properties section:
| Field | Description |
| General | |
Label | Specify the name for the formula widget. |
Subtitle | Specifies the text which you want to display just beneath the Title. You may use it to describe the purpose of the control or the way it should be used. |
Precision | Specifics the decimal point precision for the formula output. You might specify the precision of the decimal point from negative or positive. |
| Informative | |
| Help Text | Provide a help text that gives the user an idea of the required format in a way to prevent input errors. It can be keywords to search the formula field. |
Rich Text | Select it to enable the text as rich text and interpret as rich text. It allows the administrator to make the text in bold, italicized, etc.
|
Tooltip | The tooltip is displayed when the user hovers the mouse cursor over the object/field/control. |
Figure: Rich TextAdvance
The formula can be built in the Advance tab. Using the Advance Tab the Application Designer can enter the formula required for calculation.
To know more about the fields that are available under the Advance section, see Field Description.
Figure: Advance
Field Description
This table contains the list of fields and their descriptions that are available under the Advance section:
| Field | Description |
| General | |
Build the formula here | Mention the formula in the text area. Type $ to view all available Numeric fields and functions.
|
Validate | After entering the required formula, click Validate to check the syntax of the formula. |
Figure: FunctionsAppearance
The list of Appearance setups using which the Application Designer can configure the appearance of the formula widget which are mentioned.
To know more about the fields available under the Appearance section, see Field Description.
Figure: Appearance
Field Description
This table contains the list of fields and their descriptions that are available under the Appearance section:
| Field | Description |
| Text | |
Label Layout | Select the layout of the formula field, such as float, horizontal, or vertical. |
Upload Icon | You may choose to upload a specific icon or image for the formula field. If you wish to delete the uploaded image, hover over the image and click the delete icon. |
Icon Position | Select left or right to place the icon for the formula field. |
Was this article helpful?