User Manual Design - Creating your data structureCreating a calculated form field

Creating a calculated form field

In ActivityInfo, you can add a form field that does automatic calculations. For the moment, only basic mathematical expressions are supported: + - * /.

To be able to use this type of field, make sure to assign a code to the quantity fields you want to use in your calculated expressions.

Calculated fields will not appear when performing data entry but they will be viewable when reviewing entries. Just like Quantity fields, they can also be used in Reports.

Access Open Form Designer

Access Open Form Designer

Add a calculated form field

Defining the properties of your calculated form field

Define the expression of your calculated field

Expressions in a Calculated field can only reference other fields within the same form.

Field codes must be unique within a form, an error message will appear if you attempt to create a duplicate code.

Don't forget to save!

Don't forget to save!