Grid Customizing
Previous  Top  Next


Just about everything you see in and on the grid, from visual elements to behaviour to selection methods can be customized to other settings or defaults. To see a comprehensive list of options, click Grid Options.

How to change my visible columns

The most common feature to be customized of a grid is the visible columns. This you can do using any of the following methods:
·gridquickcustomizeThe quick way - Simply click the quick customize button in your grid view and select or deselect columns  
·The even quicker way - Simply click on a column/row header and drag it out of the window  
·gridcustomizeThe old way - Click your Grid toolbar button then click Customize, now drag and drop your columns from the Customize Dialog  


Enable and Disable column sorting

This is as easy as clicking on the column headers. You can do this with multiple columns using the Shift key while clicking column names/headers. led-triangle-blue Clicking your column headers will refetch your data from MySQL using an "order by" clause, i.e. server-side sorting. If you wish to remove sorting, just hold Ctrl whilst clicking the same column headers. Client-side sorting is accomplished by dragging your column header to the group by section of the grid, i.e. MyCon will automatically sort and group your data according to the column(s) you dragged into this area, clicking the column header while in the group by section will again result in a server-side sort.

Enable and Disable column grouping

gridgroupingThis is also as easy as just dragging and dropping your column header to the "Drag column here to group by " area. led-triangle-green You can do this with multiple columns

Reording my column sequence

gridreorderJust grab a column with your mouse and drag it to the new position in the grid. led-triangle-green You can also rearrange rows in the Card View the same way.

Getting a SUM, AVG, MIN, MAX, COUNT for my data's column or on a group by basis

gridsummariesRight click your column header, from the pop up menu, click Footer. The Grid will now display a footer, right click in this area and pick the computation you would like performed on the data above this column. You can also get these summary calculations for on a per group by basis by clicking the Group Footer option instead of the Footer.

How to make one of my columns a preview column

gridmakepreviewIn your Folders section, right click your table folder and click Properties. Now select the Columns Tab and scroll to your column you wish to become a preview in your grid (led-triangle-amber Previewed data can not be edited in the Grid) Make sure this column is a text type, i.e. VARCHAR, CHAR, etc. Now move to the Options column and select the GridPreviewColumn from the dropdown editor.

How to change my default editor for a specific column

Exactly the same as the previous section, just change your Default editor to one you prefer in the Editor column.

How to make a column a caption in the Card View so I can expand and collapse my cards

Exactly the same as the previous paragraph, just check the CardCaptionColumn in the Options column.