Comment on page
Maths Field
Our Maths Field gives you the ability to write basic equations using the values of fields in that bloc. For example, if Field A has the value 13 and Field B has the value 40, then to add those and have the result shown in the maths field, the maths field equation will look like the following field_a + field_b. It is useful for working with counts of totals, or other uses like creating invoices.
Note: The result of the equation is updated every time the Rules/Actions are triggered for a field that is inside the equation. For Example, if Field A and Field B are in the equation, when the rules are triggered for Field A the maths field will attempt to update.
For this reason, if Field A or B are text fields you must press enter or tab for the maths field to take effect. To get around this you can apply the Trigger rules on Keypress parameter. This will mean the equation will update as you type.
Note 2: And understanding of our Field Slugs is required to use this field. However, you may find it intuitive enough to use by itself by simply clicking "View Field Slugs" and begin clicking the fields you want in the equation.
A slightly more complex example, where we add multiple Field A by Field B, divide this result by 4, and then add the value of Field C. See Below for the output of this on the bloc:
As per the above equation, 6 * 5 = 30, 30/4 = 7.5 and finally 7.5 + 4 = 11.5
It is also possible to use functions for more complex calculations, e.g min, max and avg
An example of how to use min function. In this example the output is the smallest value between field_1, field_2, field_3 plus 20
Last modified 10mo ago