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 a 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
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 |