Logo DarkLogo Light
  • Home
  • KB Articles
  • How to do loads of stuff with the grids

How to do loads of stuff with the grids

Last modified: July 16, 2019
You are here:
Estimated reading time: 2 min

The grids are pretty powerful. There is a lot you can do with them.

Column controls

Change the order of columns To move a column, simply “left click and hold” on the column header and drag the column to where you want it.
Hide/Add columns First, click on the “Column Chooser” icon which should be at the top right of the screen. This will then open a pop-up screen.  There may already be some hidden columns listed her.
To remove a column, drag the column into the pop-up screen.
To add a column, drag it from the “Column chooser” to where you want it
Resize column In the column heading row, hover your mouse over the right-hand side border and the pointer will change to a resize icon. Left-click and resize the column.
Pin/Fix a column to the left or right Right-click on the column heading and you will see a few options, one of which is Fix either to the left or the right. Simply click on the one you want and the column will be moved to the left or right and pinned there. 
To undo, simply right click and choose Unfix

Sorting and filtering

Sort by a single column Simply left-click on the column heading and the grid will be sorted by that column, e.g A-Z. Click again to sort in the other direction, e.g Z-A.
If you right-click on a column heading, you will see extra options.  
Sort by multiple columns To sort by multiple columns when using mouse and desktop, simply shift and left-click on each column in turn.  When you next click on a column heading, the multi-column sorting will be cleared. 
Filter Click on the Filter icon in the top row and apply your filtering conditions. Depending on the data, you will be presented with multiple filtering functions, e.g date functions for dates and text options for text.
You can apply filters across multiple columns.
Clear filters To clear a filter in one column, hover on the filter icon and click on “Select All”. 
To clear all filters, click on the Clear button top right. 


Search within a column To search within a column, use the search field under the Column header. 
Global search To search the whole grid, use the global search field at the top right of the page.
This search will only search visible columns. Hidden columns are not included in the search.


Grouping is very powerful and incredibly easy. Simply “left click and hold” and drag a column heading to the text “Drag a column header here to group by that column“at the top left of the table. You can drag multiple columns and you can reorder the column headings in this are to change the order in which the grid is grouped .

To Ungroup, simply drag the column header back down to the grid.

Was this article helpful?
Dislike 0 0 of 0 found this article helpful.
Views: 45

Leave A Reply

WordPress Video Lightbox Plugin