Cflow provides an Arithmetic Operation feature that allows you to perform simple math operations and automatically populate the result in a designated field. This is useful for calculations within forms where manual input should be avoided.
How It Works
You can configure a formula to calculate a field’s value based on:
- One or more other fields
- Constant numeric values
- Conditional rules (if needed)
Example Use Case
Let’s say you have a form with:
- Quantity field
- Unit Price field
You can create an arithmetic rule so that the Total Price field automatically calculates:
Total Price = Quantity × Unit Price
To calculate a field using other fields in your form, follow the steps below:
- Go to the Advanced tab in the Field Properties panel of the target field (e.g., Total).
- Under the Arithmetic Operation section, click Add Operation.
- Select the first field for the calculation – for example, choose Quantity.
- Set the operator – for instance, select Multiply.
- Choose the second field to be used in the operation, such as Price.
- If needed, add more fields by clicking Add New.
- To apply this operation only under certain conditions, click Add Condition and define rules using field name, operator (e.g., equal to), and value.
- Use Add Nested Condition if your logic requires grouping multiple conditions.
- Once configured, click Save to apply the arithmetic logic to the field.