A grid is an aggregated view of all the records within an entity. Each row of a grid is one record and each column is one of the grid properties. Thus, each cell displays a value of a property for a record.
For example, you can open a grid of all the Contacts.
In this example, you can immediately see some major details of our contacts, such as their first and last names, email, phone number, etc.
You can adjust and save grid views, update and delete grid records, get to the Edit forms and View pages of any record on the grid, and even export all the data in the grid as a .csv file.
Getting to a Grid¶
There are several ways to get to a grid.
- Choose the relevant option in the menu bar. For instance, select the “Contacts” menu item to get to the “All Contacts” grid, click the “Manage Custom Reports” menu item to get to the “All Reports” grid, and so on.
- Find it in the Shortcuts.
- Click the grid link on the View page or Create/Edit form of a record.
If you have reached a View page or Create/Edit form from a grid, and now click link to get back to the grid, it will look identical to when you left it (the same filters and order will still be applied).
Adjust a Grid¶
Change the Table¶
You can change the set of details available in the grid (if permitted) and its order of columns by going to the right corner of the grid and clicking the settings icon .
To show/hide a column on the grid, check/uncheck it in the “Table Settings”.(The list of columns is defined by the system administrator using the Show On Grid setting of the entity fields).
To move a column on the grid, move it in the form: click on the “Sort” icon opposite to the column name, hold the mouse button, and drag the column to change the order:
You can apply filters to choose specific items to be shown in the grid.
Of course, if there are a lot of contacts, they won’t all fit on one page. In order to find the required contact in the grid, you can use the grid filters.
Some filters are available by default, but the set of filters can be modified using check-boxes under the “Manage Filters” menu on the left. (The list of filters is defined by the system administrator using the Show Grid Filter setting of the entity fields).
The list of properties that can be used as filters is defined by the system administrator using the “Show Grid Filter” setting of the entity fields.
Click the arrow on a filter to choose the required values. Available value setting depend on the field type.
If more than one filter is active, only the the records that meet requirements of ALL the filters are displayed. For example, we have filtered the “All Contacts” grid so that it only shows Jameses Browns from California.
By default, grids are sorted in ascending order by the first column. You can sort them by any field and in any order – it is enough to click the column header. An upward or downward looking arrow will appear by the column name.
Other Grid Controls¶
You can adjust any grid view using the action buttons displayed right above the grid.
- Change the amount of items displayed per page: View Per Page
- Scroll pages (if there is more than one page of records):
- Refresh the grid (i.e., get the newest details on the displayed records):
- Reset the grid (i.e., clear all the filters applied to the grid):
In some grids (as in the example), you can export all the details shown in the grid as a .csv file.
What You Can Do on a Grid¶
Create New Records from a Grid¶
If permitted, you can initiate the creation of a new record directly from the grid. Right above the grid, there is usually a Create New … button. Click it, to get to the Create form.
Edit Records on a Grid¶
If permitted, you can edit the records directly from the grid. Beside each cell there is an edit icon. Click it twice, in order to edit the value.
Click the check to confirm the change, or the cross to cancel it.
Delete and Merge Records on a Grid¶
If permitted, you can delete records.
- To delete a record, hover the cursor over the action buttons (the last column) and click .
- To delete several records (where available), check the record boxes (corresponding rows will be highlighted) and click the bulk delete action.
In the same manner, you can merge several records (if the corresponding capabiltiy has been enabled). Currently, merge can only be done for accounts.
Get to View Page and Edit Forms from a Grid¶
If permitted, you can get to the View Page or Edit form of any record in the grid.
To get to the “Edit” page, hover the cursor over the action buttons (the last column) and click .
To get to the “View” page, hover the cursor over the action buttons and click .
You can export all the data displayed in a grid as a .csv table. To do so, click the Export Grid button and select “CSV”.
The file will be saved in compliance with your browser settings.