Fields Formulas

If you want to change a field value based on other fields, you can use a field formula

For example, if you have an area field and a width and a height field, you can write this formula to set the area value

[area] = [width] * [height]

The area field must be of type “fixed value” , “php variable” or “unit price”

You can also use the fields formulas for setting up conditional calculations

Example:

[price] = IF([width] > 100, 15, [price])

In this example, the price will be set to 15 if the width is bigger than 100, else the price won’t be changed

Was this article helpful to you? Yes 1 No 1