How to change the form field calculations properties?

This article explains how you can change the calculation properties for your form fields.

You can set up Text Fields and Combo Boxes (Dropdown Menus) to perform math calculations.

  • Click into Edit Mode.
  • Select your form field.
  • Choose the Properties icon.

 

 

  • Open the Calculations Tab.

 

mceclip18.png

 

We recommend configuring these fields with relevant number settings first. You can choose between:

 

Quick Calculations

Step 1 - Choose the calculation result field

You will need to choose the field where the calculation results will appear.

 

Step 2 - Choose math operation

  • Choose Predefined next to Category.
  • Next to Predefined choose one of the following options

 

mceclip19.png

 

Step 3 - Choose the fields involved in the calculations

  • Click Change next to Fields.
  • Choose the fields.
  • Click Apply.

 

mceclip20.png

 

Advanced Calculations

You can write out your own equations with advanced calculations. You can also use a script.

 

Write out your own equations

Please adhere to the order of operations as you create equations.

  • Choose Simplified field notation next to Category.
  • Click on Set. A box will open where you can enter your math equation.
    • Enter each field name (make sure all capitalization matches) and separate the field names with the correct math symbol.
    • As an example, to perform division, it would be field1/field2.
    • Another example can be set up like field1/field2+field3*field4, and in this case, it will add the product of fields 3 & 4 with the results of dividing field 1 by field 2.
  • Click Apply to confirm.

 

mceclip21.png

 

Use a script

You can use JavaScript to perform more complex equations.

  • Choose the Custom calculation script.
  • Click Set next to Script.
  • Enter your code.
  • Click OK.

 

mceclip22.png

Was this article helpful?

Yes No
Have more questions? Submit a request