Creating Calculated Fields - Unity Forms - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external - Standard - Premier - Standard

Unity Forms

Platform
OnBase
Product
Unity Forms
Release
Foundation 24.1
License
Premier
Standard

A calculated field can be created from the Toolbox. The Calculated Field control allows you to insert a field into the form and define an expression for that field to define the calculated result. These calculated fields can be added as a stand-alone field or within a repeating section or table (including repeating sections and tables bound to a Multi-Instance Keyword Type Group). The values are not stored, but calculated in real time.

Calculated fields are automatically configured as read-only fields. Calculated fields cannot be changed to other control types and cannot be linked to Keyword Types.

A stand-alone calculated field may reference any other stand-alone field on the form. I t may not reference any fields contained inside repeating sections or tables.

A calculated field contained inside a repeating section or table may reference any field within that repeating section/table or any stand-alone calculated field on the form. It may not reference any fields contained within other repeating sections or tables.

Calculated field concatenation works with all data types supported by the Forms Designer, including: Numeric(9), Numeric(20), Text, Date, Currency, and Floating Point.