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