Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
Choose what type of formula to build by tapping the desired component tab.
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.
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.
The image below shows the Boring form and its associated 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.
While still in the Formula Builder, fields from all other forms in the template can be accessed by selecting the Aggregate Fields tab.