How to create formula field
Formula fields are dynamic calculation fields that empower you to display calculations based on different numeric values. To create a formula field:
- Select Add Field > Formula in design mode.
- From the parameter list, choose any numeric field to add to your formula editor.
- Create your formula, for example,
{{Amount}} * {{Price}}
. - Save this field, and it will automatically showcase the calculated results in both the grid and the form for each entry.