Change the appearance of data entry grids

Show and hide columns

1. Click or tap next to any column heading.

2. Select Columns.

3. Choose from the following actions.

   • Check a column name to display it in the grid.

   • Uncheck a column name to remove it from the grid.

Change column widths

Note: Available on desktop browsers only.

4. Position the cursor on the boundary between two columns.

5. Choose from the following actions.

   • Click and drag right to expand a column.

   • Click and drag left to shrink a column.

Reorganize order of columns

6. Click a column heading.

7. Drag the column heading to a new column position. A + sign is displayed as you move the column.

Change grouping of data items

Data items are initially organized by Group, as defined in your tour configuration.

8. Click or tap a column heading.

9. Drag the column heading up to the row above the column headings. You can place it before or after Group, as required. A + sign is displayed as you move the column.

   To remove a group header, click or tap beside the header you want to remove.

Sort columns

10. Click or tap the column heading you wish to sort.

11. Click or tap .

12. Choose from the following actions.

    • Select Sort Ascending to display items in ascending order.

    • Select Sort Descending to display items in descending order.

Filter data items

13. Click or tap the column heading you wish to filter.

14. Click or tap .

15. Click or tap Filter.

16. Click or tap your selection criteria.

    For alphanumeric data items, such as UOM, select from:

    • Is equal to

    • Is not equal to

    • Starts with

    • Contains

    • Does not contain

    • Ends with

    You can also create an And or Or expression, as required.

    For Boolean data items, such as Limits violated, select from:

    • is true

    • is false

    To view only specific groups, first show the Group column and then check the desired group names from the filtered list.

    To view all data items that have limit violations, show the Limits Violated column and filter on all rows by selecting is true.

    To quickly identify all data items that do not have values, click the Value column header to sort.

17. Click or tap Filter.

Clear filtered data items

18. Click or tap the column heading you have previously filtered.

19. Click or tap .

20. Click or tap Filter.

21. Click or tap Clear.