Configure the columns of the configurable grid and the data that is shown in the configurable grid. The related query defines which columns are available for the grid.


Standard procedure

1. Click Mobility design.
2. Click the Forms tab.
3. In the list, find and select the desired record.
4. Click Edit.
5. On the Controls tab, in the list, find and select a control of type Configurable grid.
6. On the Details tab, in the Query field, click to follow the link.
7. Sub-task: Add range to query ranges.
  7.1 To make the query results more specific for the configurable grid, you can add a range to the existing query ranges.
  Click Add.
 

Note: You cannot change or remove ranges that are defined on the query.

  7.2 In the Datasource name field, enter or select a value.
  7.3 In the Table field field, enter or select a value.
  7.4 For each added range, set the relevant condition.
  In the Condition field, select an option.
  7.5 For each added range, set the value for the condition.
To set the value, you can use a variable, a function, or a fixed value.
  In the Value field, enter or select a value.
 

Note: You can only use variables and functions that are applicable for the application to which the query is assigned.

  7.6 To review the query results in the preview, click Refresh.
8. Sub-task: Create grid configuration.
  8.1 You can create the grid configuration based on the query fields.
  Click the Fields tab.
  8.2 Select the query fields that you want to add to the configurable grid.
  8.3 Click Create grid configuration.
9. Sub-task: Configure grid.
  9.1 Define additional settings for the query fields that you added to the configurable grid.
  Click the Grid configuration tab.
  9.2 In the Label field, you can select the label for the display name of the column.
 

Note: If no label exists, you can click Generate labels from text. As a result, for all fields without a label defined, a label is created based on the value in the text field.
Before you create labels from text, define the known labels for the fields.

  9.3 In the Width field, define the width of the column expressed in a number of pixels.
 

Note: Enter a width of 0 to hide the column.

  9.4 You can link an application variable or a form variable to a field.
  In the Linked variable name field, enter or select a value.
  9.5 If a variable is defined, the label of the related extended data type can be used as display name for the column.
By default, the label of the extended data type is not used.
  If you want to use the label of the extended data type, select the Get caption from extended data type check box.
 

Note: If you use the label of the extended data type, do not fill in the Label.

Related to Notes

Configurable grid

 

Provide feedback