Calculated Fields With SXP Extensibility

First published on: 03/20/2025/12:00 pm

Calculated Fields 

Calculated fields/formulas can be used when the field's value is calculated based on the other fields in the record.

For example: Total price = units sold multiplied by unit price.

To define a calculated field, navigate to the data store. 

Check 'Enable Formula' on the field properties. 

Once enabled, open the formula editor . 

The editor explains how to write the Javascript to perform the needed calculation.

Once this is complete, the setting will apply to any grid or form using these fields.

In the screenshot below, totalPrice is calculated as the sum of all documentList.ItemPrice.