Select the data field column whose fields should be calculated and then select the “Formulas” tab in the “Field Properties” dialog under the “Database” menu.
In this tab you can enter a formula that will be the “expression for a new record.”
The definition for a calculation formula that will be continuously updated takes place in the entry field “Formula,” which also defines the selected field as a calculated field.
It is possible for the formula to contain relations to other fields within the calculation. The syntax for this is:
In the drop-down menu at the bottom of the tab you can set whether the calculation results for this field can be overwritten in the entry form, or whether you would like to prevent them from being overwritten.
For an overview of the possible calculations, see the list of calculation formulas under the “Manual” menu.