Collect Forms – Table Form Field Type

The "Table Form" field type allows users to enter data directly into a tabular grid in Collect Mobile. Available fields on the template can be added as columns in the table form field (e.g., parameters such as time, pH, turbidity). Users capturing data can add new rows (i.e., records) to the table form field grid. An overview of the Collect Mobile user interface and functionality for entering data into a Table Form field type is available here.

Note: The attributes applied to a field are carried through to the column in the Table Form. For example, if the field has the Visible attribute that evaluates to FALSE, it will not appear on the Table Form field. However, there are two differences to make note of:

•When triggered, the Warning attribute is displayed as a yellow triangle with an exclamation mark icon in the Collect Mobile Table Form field and the cell is highlighted with a yellow outline.

•When triggered, both the Error and Required attributes are displayed as a red octagon with an exclamation mark icon in the Collect Mobile Table Form field and the cell is highlighted with a red outline.

After adding a Table Form field to a template in the Template Designer, several properties are available to be configured. The following properties are specific to the Table Form field type.

Records Displayed Per Page – Defines the number of records in the Table Form field in Collect Mobile. The default number of records displayed per page is 10, with a minimum value of 1 and a maximum value of 50.

Form Name – The Form Name is a required property. The Form Name property dictates which form the table will interact with. The drop-down list includes all parent-level form sections and any child form sections that relate to the form in which the Table Form field resides. When pointing a Table Form field in a parent form down to a child form, adding new rows in the Table Form field will automatically assign them as child records to the parent. It is recommended to use the Form Filter attribute to limit the view of data to only the child records of the parent. For example, to show FieldParameter records only when they are children of the current record, use a formula like the following in Form Filter: EQ([#id],[FieldParameter.#parent_#id]).

Columns Tab

The Columns tab is used to define which fields will be the column headers in Table Form field. Columns are required and cannot be empty.

Selecting the Add Columns option will display compatible field types that are part of the associated form selected in the Form Name property. After opening the Add Columns option, a Select All check box is located next to "TYPE" and "REFERENCED FIELD" and allows for adding all compatible fields to the columns section, or columns can be added by individually selecting the desired fields check boxes. If all compatible fields have been selected, the Add Columns option will become inactive. Once the fields are selected, they will be displayed in the Columns tab, as shown below.

Column names displayed for Table Form fields in Collect Mobile can be either static, where the column name matches the text present in the Static Column Name field, or dynamic, where the column name is determined by a formula in the Dynamic Column Name. Static column names can be edited by selecting the text in the Static Column Name field. To dynamically set a column name, click the Formula button, which opens the Formula Builder, to build a formula and dynamically adjust the column name. The Formula button will be blue if a formula is configured for the Table Form field. Columns can be reordered using up/down arrows, which opens a Move Selected Fields dialog, allowing the selected fields to be moved above or below the specified column. Fields can also be reordered by dragging and dropping one at a time.

Note: If configured, the dynamic field name will take precedence over the static field name.

A Delete icon allows selected columns to be removed from the Table Form and a Remove All Columns option allows for all columns to be removed at once. Any columns that have not been added to the Table Form, or have been added then removed, are available by selecting Add Columns. The check box option allows multiple columns to be selected and be used in conjunction with the reordering and deleting options. Selecting the Clear Checkboxes option deselects all checked columns.

Note: Additional attributes, by selecting the Attributes tab, that are available include Visible, Editable, Warning, Error, and Form Filter. An example demonstrating the use of the Form Filter is available in the General Water Sampling Template on the Community Center.

Compatible Field Types

•String

•LongString

•Date

•Time

•DateTime

•Integer

•Decimal

•Selector

•Dynamic Selector

•Boolean

•Formula

Notes:

•The LongString field type will display as one line of text unless line breaks are manually entered, by clicking "Enter".

•The Boolean field type will display as a check box.