Formulas

<< Click to Display Table of Contents >>

EQuIS 7  >>  Collect > EQuIS Collect Enterprise > Form Designer > New Form Template > Forms and Fields > Formula Builder >

Formulas

Choose what type of formula to build by tapping the desired component tab.

 

Formula Builder Components 

 

Value – The actual value attributed to a field. Values may be numeric (start with a number) or a string (start with a quote). Some field values, for example a geography field, have string representations which are in JSON format.

 

Function – A list of all functions available to be used in building formulas, described in detail in the Function Descriptions article.

 

Fields – This tab relates to any existent form fields on the current working or selected form.

 

System Fields Refers to general, universal fields that are not restricted to fields on the form (e.g., the date/time the form was started). These fields are listed on the Fields tab under the Section Fields header.

 

AggregateFields – Refers to fields inside aggregate functions, which process all values of fields on specific tables. Aggregate functions and fields allow the extraction of data from other tables and executing more complex validation tasks. For example, a user can determine if a measured value is stable (has not changed much over the last three readings) or can extract a value from a related form.

 

Snippet – This tab allows the user to save a formula to use in another field or on other forms, described in detail in the Formula Snippets article.

 

Test – This tab allows for testing various pieces of a formula by entering test values. Note that for complete testing of formulas, the template can be set to test mode and downloaded on the device.

 

Fields Tab Example

 

The fields shown in the Fields section of Formula Builder correspond to fields added to the form template, as designed in the Template Designer. The fields are organized by the forms to which they belong. In this example, the BoringLog2 template has three parent forms: Project, Boring, and Test Pits. The Boring form is a parent form with six child forms.

 

fields_form_designer2

 

The image below shows the Boring form and its associated fields.

 

Correspondence template builder fields - form fields

 

The Fields tab displays the standard fields and section fields (i.e., system fields) that belong to the form currently being configured. In this example, the fields relate to the Boring form and its associated child forms.

 

Fields in Template Builder

 

While still in the Formula Builder, fields from all other forms in the template can be accessed by selecting the Aggregate Fields tab.

 

formula_builder_aggregate

 

formula_builder_aggregate2