Real-Time Equation Calculations in Forms

Learn how equation fields can calculate and dynamically update in real-time within forms.

Overview

Including equation fields in form views allows for the display of read-only values. Equations can be calculated and updated in real-time in the Live App within form views as long as the fields used to perform the calculation are included in the view. 

Example

Imagine you are the admin of a Purchase Orders app and you need to make changes to a line item in an order. You must adjust both the product quantity and price to ensure accurate record-keeping.

Since the form includes the Price and Qty fields which are the two fields used to perform the equation field's calculation, the Total equation field will dynamically adjust based on the values entered in the Live App for each of those fields.

See the equation field (Total) update in real-time in the form below:

Current Limitations

• Only numeric equations will update in real-time; date equations currently will not.

• All necessary fields used in the equation must be included in the form for the equation to be calculated in real-time.

• Equations displayed on the form that use other equations will display inconsistent results as there is no set order in which these equations are processed.

• If values from connected records are needed to perform the calculation, then the equation value will not update automatically in the form.