Data grid
This page outlines the basic functions of the new grids and provides examples to enhance your workflow.
Last updated
This page outlines the basic functions of the new grids and provides examples to enhance your workflow.
Last updated
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.
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.
Each column includes a built-in menu, accessible by clicking the vertical ellipsis icon (see Figure 2).
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).
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.
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.
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.
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.
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.
This section offers tips to help you become familiar with the new grid and use it effectively to enhance your workflow.
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.