Data Sets

<< Click to Display Table of Contents >>

EQuIS 7  >>  Collect > EQuIS Collect Enterprise > Form Designer Page > Forms and Fields >

Data Sets

Data Sets are a method of further constraining form requirements and maintaining uniqueness in the data as well as facilitating the automation of index or interval generation. The configuration tools allow the user to define the parameters that the data set must follow.

 

An example use for applying data sets is for recording borehole measurements (well development, mining, etc.). Using data sets can ensure no overlapping depths and keep a consistent series of measurements.

 

To define a data set, select the Data Sets button on the Fields section of the Form Setup page on the Form Designer page.

Col-Form-Setup_Data_Sets

Available data sets types are:

Single – Looks at the starting field and continues on a set increment with no end point (start must fall within Min and Max). When a new record is created, the start is incremented by the increment.

Interval – Looks at two fields, start and end, and makes sure there is no overlap between them. When a new record is created, the increment is used to produce a new interval that starts at the previous end and has a length of increment.

Unique – Defines a unique value with no specific start, end or increment.

DataSets Types

Select the Data Set type and then configure as desired. Configuration options include:

Start – Defines the Start value. For use in single and interval data sets. Selecting the Start button loads the fields available in the editing section of the form. Select the desired field for data set definition.

End – Defines the End value. For use in interval data sets.

Minimum – Defines the minimum value. Selecting the Minimum button opens the Formula Builder to allow definition of the minimum check for the data set of the specified field.

Maximum – Defines the maximum value. If no value is set, then will continue based on set increment. Selecting the Maximum button opens the Formula Builder to allow definition of the maximum check for the data set of the specified field.

Increment – Defines the fixed increase in value. Selecting the Increment button opens the Formula Builder to allow definition of the increment check for the data set of the specified field.

DataSet Organization

Operations available on the Data Sets Organization window are:

Cancel – Exits the Data Sets Organization window without saving.

Clear – Clears the defined data set.

OK – Saves the defined data set and closes the Data Sets Organization window.