Overview

The formulas module enables users to perform advanced data manipulations and automations through an intuitive interface, without writing any code. It supports a wide range of functions, including arithmetic operations, conditional logic, text parsing, date handling, and data aggregation. Users can reference fields, variables, and external data sources within formulas to dynamically update values and trigger actions. This module is essential for building complex workflows, performing real-time calculations, and creating custom user experiences, all while maintaining flexibility and scalability in the application.

Key Components of an Activity

1. Inputs

• Inputs are parameters that define the variables used in the formula, allowing dynamic behavior based on user-defined values at runtime.

• Inputs can come from the UI or other systems and can be required or optional. They are validated during execution.

• Example: In an employee management system, a formula to calculate the remaining leave request balance might have the following inputs:

  • RequestedLeaveDaysNumber: The number of days requested for a leave.

  • TotalLeaveEntitlement: The number of days entitled for an employee.

  • UsedLeaveDays: The number of days already used by an employee from the entitled days.

2. Formula

• The formula lets you define the steps needed to calculate a specified outcome.

• Example: The formula to calculate the remaining leave days might have the following formula:

  • Remaining Leave Balance = TotalLeaveEntitlement - (UsedLeaveDays + RequestedLeaveDaysNumber)

Formulas enhances the technical capabilities by providing a powerful, yet accessible tool for automating processes and integrating data seamlessly.