Select evaluated fields to use in custom views

Evaluated fields are fields that are calculated using the contents of other fields or other constant values.

To add an evaluated field to view

1. Open the CustomViewField Collection Editor.

2. Click Add.

3. Next to the Table field, select <evaluated>. The Calculation property appears.

   

4. Next to Calculation, enter the formula for the field; for example:

   [Field1] *2

Notes:

• An evaluated field can only reference fields that are a part of the view. The fields do not have to be visible in the client, ShowInGrid property, but they must be a part of the view.

• It is a good idea to enclose fields in square brackets; for example, [Field 1] when you reference them.

Related topics

• About custom views

• Custom View Field Editor

• Configure the Primary table

• Add and configure a Secondary table

• Create a join field