Configuring Calculated Fields

Understanding Calculated Fields

Within the Quik! Field Definition, several fields exist to make it easier to fill forms and satisfy form fields that combine multiple pieces of information (e.g. when a form asks for an owner name, the calculated field called "FullName" is used, which is comprised of the owner's first name, middle name and last name). Calculated fields add a level of complexity when trying to pre-fill and/or process submitted form data. When prefilling data into fields, calculated fields cannot be pre-filled (e.g. set value), but the resulting value can be retrieved (e.g. get value).

When processing data that is submitted from a form, the data may be coming from either a calculated field (e.g. FullName) or from a non-calculated field (e.g. First Name, Last Name), and in some cases from both fields at the same time. It is best to look at both the non-calculated fields and the calculated fields for values.

Calculated Fields

The fields on the left column when used will automatically configure the form to use the Calculated Field popup. The right column characterizes the contents of fields that will populate when the corresponding field is used on the form.

Calculated Field

Calculation Format (including punctuation)

FullName

FirstName MiddleName LastName, Suffix

Addr123

AddrLine1, AddrLine2, AddrLine3, AddrLine4

CityStateZip

AddrCity, AddrState AddrZip

FullAddr

AddrAllLines, AddrCity, AddrState AddrZip

FullNameRev

LastName, FirstName MiddleName Suffix

OSJFullName

OSJFName OSJMName OSJLName, OSJSuffix

PrincFullName

PrincFName PrincMName PrincLName, PrincSuffix

Enabling or Disabling The Calculated Fields Feature

By default, this feature is enabled in all versions of the Quik! Forms Engine v5.3 and above. However, its property can be modified based on your need.

This can be done by setting the property ShowCalculatedFieldsPopup to False or True. (True is the default state)

For help regarding Quik! Forms and the Quik! API
Email: support@quikforms.com | Phone: (877) 456-QUIK