Data grid

This page outlines the basic functions of the new grids and provides examples to enhance your workflow.

Base functionality

The table below lists the base functions available in the grid header. With a a few exceptions, these functions are consistent across the different grids. The order matches the column headers in Figure 1.

Figure 1: Column header base options

Option	Explanation
Customise Columns	Makes it possible to select which columns should be displayed in the grid. Aslo includes search functionality.
Show filters	Displays the filter options. It is possible to define your own filters.
Density	Changes the density, that is, the spacing of the grid.
Export	Displays the export options for the data in the grid.
Expand	Expands the given grid to display more rows. Is enabled or disabled based on number of available rows in the data.

Additional functionality

Each column includes a built-in menu, accessible by clicking the vertical ellipsis icon (see Figure 2).

Figure 2: Column header menu

Expanding the menu displays a list of options for the column (see Figure 3), including sorting, pinning the column's position, and column management options. Basic sorting can also be performed by clicking the arrow that appears when hovering over a column or by clicking the column header itself (see Figure 2).

Figure 3: Column header menu options

Modifying header position and width

You can adjust the header's width by placing your cursor at the intersection between two columns and dragging to resize. To change a column's position, click and drag the column header.

Row-modifications

Each row in the grid includes a vertical ellipsis menu for row-specific options, typically located in the right-most column (see Figure 4). The menu's contents and available options depend on the grid type.

Changes made within the grid or through the menu will directly impact the system data. For instance, selecting the delete option will remove both the row and its associated data.

If the grid supports insertions, you can insert a new row before or after the currently selected row, as seen in Figure 4. However, this option may not be available in all grids. Some grids also support copying a row, along with its associated object.

Figure 4: Row options

Opening existing drawers and modals

The grid includes a column for opening the associated drawer or modal, located in the left-most column by default (see Figure 5). When clicking the icon, the results will be displayed on top of the full-screen drawer. As seen in Figure 6.

Figure 5: Open cargo ports edit modal

Figure 6: Edit cargo ports modal opened

Filters

You can use the grid's filter option to create custom filters. Some grids also offer quick filters, which are not customizable, unlike the base filters in the column header.

Figure 7: Custom filters applied on the distance column

Column aggregation

The new grid allows you to apply aggregations to numerical columns. This option is accessible via the vertical ellipsis menu that appears when hovering over a column. Figure 8 shows the menu and the result of applying the "sum" option to the distance column.

Figure 8: Aggregation options, and sum applied to distance column

Suggestions on how to use grid efficiently

This section offers tips to help you become familiar with the new grid and use it effectively to enhance your workflow.

Keyboard shortcuts

Using keyboard shortcuts is a powerful way to boost efficiency when working with the grid. Below are general instructions for using the grid, while Figures 9–11 list available shortcuts along with brief descriptions.

• To change the value in a cell you can start typing when it is highlighted, or double click/press ENTER to go into edit-mode of that cell

• When in edit mode of a cell with select menu, SPACE opens the menu showing all options, and you can select options with ENTER.

• ESC exits edit-mode of a cell and discards the changes made.

Figure 9: Shortcuts for Navigating the grid

Figure 10: Shortcuts for Selection in the grid

Figure 11: Shortcuts for Sorting in the grid