Configuring Table Columns

To configure the columns in a table:

1. Click on the 'Add' button under the Columns heading
2. The fields to be completed are as follows:
   1. Position: This is automatically populated and indicates where in the table the current column will be displayed. The order can be changed after all fields are mapped.
   2. Module Type: This is the module name where the field you wish to display is held. Select a module from the drop down selection box. You can display fields from related modules in tables. For more information, see Related Fields in Tables.
   3. Field: This is the name of the field you wish to display in the column. Field labels cannot be changed in the Table Settings menu. The label displayed is taken from the value entered when the field was first mapped in iEnterprise Mobile™. To change the field label, see Changing Field Settings.
   4. Is Total: Selecting this box will place a total at the bottom of the column.
   5. Is Preload: If you want values in this column to be preloaded, select this box. You will also need to define preload rules, see Configuring Table Filters and Preload Data.
   6. Size: Width of column in pixels, tables can be displayed in a full screen format and the width available is 982 pixels. You can enter any value you wish to customize the width of columns. If no value or a 0 is entered, columns are automatically calculated.
   7. Sort: Select 'yes' or 'No' to sort the data in the table.
3. When all fields are complete, click on Save icon to complete configuration.
4. Repeat steps 1 to 4 for all remaining columns.

When the configuration of the columns has been completed, you can change the order in which they are displayed.

To change the order of the columns:

1. Click the 'Order Change' button.
2. In the new window will be displayed your columns. Click and drag to rearrange their position.
3. Once done, either click 'Update' to save these changes, or the 'X' to cancel and return to the previous arrangement.

Configuring Table Filters and Preload Data

To configure data filters and set up preload data code:

1. Click on the Add button under the Filters heading
2. If you are configuring a preload rule, the fields should be completed as follows:
   1. Type: This should be set to Required.
   2. Label: A label is required to help identify the preload rule, but it is not displayed on a device.
   3. Expression: This is where the JavaScript code that defines the preload criteria is entered. For more information, see the iEnterprise Mobile™ JavaScript Guide.
3. If you are configuring a filter, select Filter Option in the Type field.
4. The remaining fields should be completed as follows:
   1. Label: This is the label displayed on a device next to the filter.
   2. Type: Selecting Text will display a search box, where a user has to type a value before searching to filter results. Selecting List will display a drop down selection box for a user to select from a list of possible values.
   3. Module IDs: This box is used to select which module you wish to use to create a filter. Data can be filtered based on any field within a module related to the current module you are configuring. Select the module name using the drop down selection box.
   4. Field: This is the field that you wish to use for users to filter data. Select using the drop down menu.
5. Click on the Save button to complete configuration of the filter or preloaded data rule.