Specials Groups Estimated reading: 2 minutes Groups Groups are defined by the ADMIN and not available for all tables. The purpose is to create an additional structure in the Record List. How to select a group Click the icon GROUP SELECTION This opens the selection window. Country and region are selected in the following example. Click on the checkbox before ‘Country’ to select this group. In order to select the ‘Region’ at the same time, press the shift key and click the check box before ‘Region’. Fig.1: Selection window groups Note: The order of the groups in the drop down menu depends on the position of the column in the Record List. If the column ‘City’ is displayed before the ‘Country’, it will appear before the ‘Country’ in the drop down menu. What changes in the Record List Record List – no group selected Fig.2: No groups Record View – Group ‘Country‘ selected ‘Country’ is displayed as group header. The corresponding data records are listed below. Fig.3: Group by country Record List – Group ‘Country’ and ‘Region’ selected ‘Country’ and ‘Region’ are displayed as group headers. Example US with 3 regions. (CA, NM, OR). In case there is no ‘Region’ available the ‘#’-symbol is displayed. Example Germany (data record, field region has no value). Fig.4: Group by country and region How to reset a Group selection Choose the ‘Group Select‘ icon and uncheck the selected checkboxes.