Skip to main content
J. J. Keller Support Center

How to Use Recordkeeping Grids

 

Recordkeeping grids offer efficient, "one stop shop" displays for Safety Management Suite users to see various data in one "view". For demonstration purposes, this article specifically showcases the grid for the Chemicals Product List. This information can easily be replicated for other recordkeeping grids in SMS.

 clipboard_ed6971daacf679b9c43fdfe5978ce1690.png

 

To the right of the grid, select Columns, Filters, or Actions.

clipboard_e84717169b5d1aa35398f33fbdd0efd2d.png

 

Columns 

From the Columns fly out, select the data columns you would like to see displayed within your grid. The grid will update automatically as you are selecting/deselecting specific column types.

clipboard_ee29cb5560f2efae7afe6744059e5b70c.png

Columns can also be rearranged for custom viewing. Simply click and hold the column and drag into your desired order.

clipboard_ee5302178514fdd5408a018da647eb322.png

Additionally, columns can be resized by placing your cursor between two column headers, clicking and dragging to your desired size. Or, you can auto-size a column by placing your cursor on the right edge of the column header to reveal a double-sided arrow. Double click the edge of the column and the column will snap to an auto-sized width.

clipboard_e0a2d88fc2fa1051e00230cb4177c615e.png

 

Other Column Functions

Hover over a column header to reveal a stack of lines; click to open additional options.

1. Pin Column: Pin a column to the left or ride side of the grid

2. Autosize This Column: Snaps the column to an auto-sized width

3. Autosize All Columns: Makes all of the columns in the grid the same size

4. Reset Columns: Resets all column selections, column widths to the system default, resizes all columns to 

clipboard_eca9ac5272d8834bd104df67a451b0e60.png

clipboard_e79af9c6c3fc5d95bdddafa1927af2469.png

Filter within Columns:

Some column filters allow for specific selection/s or selecting variables (Contains, Equals, etc.).

Other columns that are "Company Data" are searchable filters, as shown in blue.

For more specific information and features about the filtering functions, see the FILTERS section below.

 

clipboard_e7eb77c157ff4c73964f9a75649c6a3b2.pngclipboard_ed6a5b12ea3b3f07c75d8410013cbbbf6.png

Column Selections:

Click the column icon to reveal another place to select additional/deselect current columns.

clipboard_e9181778de4017a7b8f13943d42907bc1.png
Click a column header to sort the grid data in ascending or descending order. clipboard_e67e75f3fea9ee280f3305e2070f7e798.png

 

Filters

Filters allow you to narrow down the results of the individual columns even further to display specific data in the grid.

Righthand Filters Menu

When using the righthand menu item for Filters, click on the arrow next to each Column name to reveal results of your current data. Select/deselect or search for the desired data to include in the grid,  The grid will update automatically as you are selecting/deselecting specific filters.

clipboard_e0c8d6532c5e7a128b6ac2eba96327da9.png


Filter by Columns in the Grid

Columns can also be filtered individually by hovering over the column header to reveal a stack of lines; click to open additional options. Then, click on the filter icon to reveal that column's filter options.

clipboard_e3457196e1845bf471687179993639386.png


Filtering with Search Filters Row

Additionally, you can search and filter right within the grid to reveal specific data. In the example below, the grid has been filtered to display specific data based on a selection from the company's Locations. Click into the search bar under the specific column. For the Locations column, you have the ability to type and search for a specific location/s and then select multiple from the list to display in the grid.

clipboard_efa97230298e4e0989d4bbb64c0fd3e4d.png clipboard_e45f4b721a483074339cc19c60f91e381.png

 

To remove a filter for a specific column, you can click the X in the search field.

clipboard_ecd68193f1e0c05c2262b15fb07e9790d.png


Hide/Show Filters

If you would like to hide (or show) the filters feature, click the cog wheel to the right of the grid and select hide/show filters. The search fields will then be hidden.

clipboard_e2f6b0a438a2b7623e5b5e8a82823fab7.png

Clear Filters

To clear any filters you may have selected for your grid, click the cog wheel to the right of the grid and select Clear Filters.

clipboard_e8cbf5c829518125f19264ed5ec302a12.png

Reset Filters

If you'd like to completely reset the grid to the system's default view, click Reset.

 

clipboard_e8bb271568fb9da183a9f9939be8694b6.png

 

Note: The final button (Save) in the settings row relates to Saved Views. See Saved Views later in this article for more information.

 

Pagination

Pagination allows for improved loading times for larger data sets. The pagination feature is located at the bottom right of the grid. Each page includes 100 records. In this example, you can see that Page 1 displays records 1-100 out of a total of 482 records, across a total of 5 pages.

clipboard_edba24061099f29f39cbc5c9f32c06fd2.png

When advancing to the next page/s you will see the record set updated at the bottom of the grid.

clipboard_ed36b077a65ff7fbbb82825dc0066551f.png

 

Understanding this pagination feature is important when selecting data for reporting purposes. The next section will discuss actions you can take within the grid, including the Select All/Deselect All feature and how it works with Pagination.

Actions

Actions are great for reporting and allows you to Export, Import, or generate CSV, Excel, or XML files based on the view that has been generated by the columns and filters.

clipboard_ec7391fda5cc388e1690b777224f5bc0e.png

The Import and Export functions take you to the Import/Export Center. This is where you can import large data sets in mass, or export all of your records out of the site. Exports are in the same format required for a subsequent import, in the event a mass update is needed.

Grid Reporting

To generate a CSV file of your entire grid (including all pages of grid data and all filters/columns you have exposed/set), select Generate CSV under the Grid Reporting section.

clipboard_e3f6edf914a5fd12fc71c84a5abb21ee4.png

Reporting from Selection

If you want to generate a report that includes only select data from your grid (ex. only 3 of the results from the grid), you can do so by selecting the checkboxes next to the desired rows.

clipboard_eb15152baaaa2c36bd96e7b08ad71110c.png

 

Additionally, you can Select All/Deselect All rows to help with including/excluding larger sets of data in reporting. Click Select All/Deselect All at the top left of the grid (shown in red below) to select all rows from the current page you are on. To include/exclude data across multiple pages, you will need to proceed through all pages and select/deselect rows you wish to display in the report. Simply click through the pagination function at the bottom right of your grid and keep selecting data until all desired rows have been chosen. You can see how many rows are currently selected at the top left of the grid (shown with the orange arrow below). As you go through each page and select more rows, this number will increase.

clipboard_ea76e1250e5ab60345dcc8e3241224a46.png

 

After all desired rows are selected, click the Actions tab. Select your preferred file format from the "Report From Selection" section.

clipboard_e3905ce413c63ebbc50b43519930cb653.png

 

Managing Selection

Here you can also "Manage" your selection by copying the data into another type of document on your device (ie. an Excel file), or by deleting the selected data and its associated information/tasks from the system entirely.

clipboard_eb478b34cd658eba2fc4443edc88d9a9a.png

Saved Views

To the right of the grid and located above the Columns/Filters/Actions buttons, locate the cog wheel. When you filter, add columns, etc. in order to view specific sets of data, you are able to save and name that grid configuration to view another time.  Additionally, you can set a configuration as a "default", allowing the page to load up that default view anytime you return to the grid.

clipboard_e4e4bbc782b5d5df11c06f20de823cd8e.png

Save a New View

When all desired data is displayed in your grid, and you'd like to save this view for future reference, click Save a New View.

clipboard_e125939dceb4453a5de3a64ab68645341.png

Enter a name for the view. If you'd like this view to be the default for each time you return to this grid, check the box for Default View.

clipboard_ed48d84b933a42fd6ba243093b10f16a2.png

To save any additional grid configurations that you set, click the Save button.

clipboard_ee8b5d073357dc62ba6afc4c1dc07fe9a.png

Name the view and Save.

clipboard_ebf19ef9d50bab4036c429ee2eec4c481.png

You will see your list of Saved Views populate in the Saved Views box. Simply clicking on the name will display that view in the grid.

clipboard_e6684ac79d91e368efd8231026424ce0c.png

Edit or Delete a View

To edit a view, click the pencil icon next to the name of the view. Here you can change the name or set/unset is as a default view.

clipboard_e29474bb5a3de042036d2e88e8a4d5f72.png

To delete a view, click the trash can next to the desired view. You will be prompted to confirm the deletion.

clipboard_ea6f8f6e12b7e8125bcead123ba5cb97f.png  clipboard_ead75b3213ca69f3b7ee6490f3cef4307.png

Note: Once a view is created, you are not necessarily able to make changes to that view. If you decide to add additional filters, columns, etc. to that view, you will need to save it as a new view. You can then delete the previous view if needed.

 

 

Quick Definitions

 

Action Function Location
Hide (or Show) Filters Row Hides the Search to Filter Row under each column

Above the grid, upper-right corner

clipboard_e4372869cc325975ddf3bf43b80ec4005.png

Clear Filters Clears all active filters

Above the grid, upper-right corner

clipboard_e0c2e5a193f62868ddc98092bebbd2fb6.png

Reset Clears all active filters and resets all grid columns to the default state when the page loads

Above the grid, upper-right corner

clipboard_e7a8b4d123b42e40095b4480c54cbe400.png

Select All/Deselect All Select/Deselect all rows on the page

Above the grid, upper-left corner

clipboard_e106304521f82786bf5d58fc1ebc8069f.png

# of Rows Selected Notes how many rows across the entire grid are selected.

Above the grid, upper-left corner

clipboard_ec3017414aa3a465f6e3d2a7c9b28befe.png

Pagination

Shows what record set is currently displayed on your grid. (ie. 1-100 of 482 means that the grid is currently showing records 1-100 out of a total of 482 records. This number will updated as you page through the grid.)

 

Also shows what page you are on and how many pages there are. (The double arrows will bounce you to the last/first page of the grid)

Below the grid, lower-right corner

clipboard_ee916149c22243ec481e7baabe570e0e6.png

Columns Opens selector for all grid columns

Right-hand grid menu

clipboard_e7800bb5e0ffca84642c38dc9beabed3b.png

Filters Opens selector for all grid filters

Right-hand grid menu

clipboard_e91b1fee11e4547183e2ea368fc8f96bf.png

Actions Opens selector for all grid-level actions

Right-hand grid menu

clipboard_e3cbb961d4afdcd9c20d80cc519587d57.png

Import Data

Opens the Import Center with the data set and "Import" pre-selected

Right-hand grid menu > Actions

clipboard_e45b4163eda9c3e94548a7bd2c2f35603.png

Export Data Opens the Import Center with the data set and "Export" pre-selected

Right-hand grid menu > Actions

clipboard_e2e4e1b3a5324636130e537d640c07a0d.png

Grid Reporting - Generate CSV Will generate a .csv file of all data in the entire grid, across all pages.

Right-hand grid menu > Actions

clipboard_e571732fb041b418c77d73be6d0de79af.png

Report From Selection - Generate CSV Downloads a .csv file with all rows, all exposed columns, with column headers

Right-hand grid menu > Actions

clipboard_e34c43c95284a9dd740276f68739d46d6.png

Report From Selection - Generate Excel (.xlsx) Downloads a formatted .xlsx file with all rows and all exposed columns with headers

Right-hand grid menu > Actions

clipboard_ec8b22eac3c4fda3b386fb043abddb68e.png

Report from Selection - Generate Excel (.xml) Downloads an .xml file with all rows and all exposed columns with headers

Right-hand grid menu > Actions

clipboard_ea885207560300d3d36f11164e57c928d.png

Manage Selection - Copy Copies all cell data for selected rows to the clipboard

With row(s) selected, Right-hand grid menu > Actions

clipboard_ebfdb6caad730b30b72c29dcb8a45d7af.png

or

Right-click the row in the grid > Copy

clipboard_e89aca1aa3aafd76a137f58cbae7ce98d.png

Manage Selection - Copy with Headers Copies all cell data for selected rows with column headers to the clipboard

With row(s) selected, right-hand grid menu > Actions

clipboard_ebd82a6d377d13d7ee946f25e2ba9dc71.png

or

Right-click the row > Copy

clipboard_e4ad2ce715fced62b1d871552fa60af58.png

Manage Selection - Print Form 301

Only visible in Incident Recordkeeping

Allows for printing of Form 301 for selected rows

With row(s) selected, right-hand grid menu > Actions

clipboard_e6d387df01b81106f55020d7665ebe780.png

Manage Selection - Delete Deletes selected rows from system after confirmation modal

With row(s) selected, right-hand grid menu > Actions > Delete

clipboard_e298b46b9ef41e2eedf301311f103e961.png

or

Menu in the grid > Delete

clipboard_e8b299aaa5d0a31c61fbf862c096e384f.png

Row Menu Opens the row-actions menu (View, Edit, Delete, etc. for this record

Grid Column 2 on the load page

clipboard_e561e05423ddca32a04454c25b91c5775.png

View Opens the view page for this record

Row Menu > View

clipboard_ec1e66f6d244fab60700ff26a7eecd688.png

Edit Opens the edit page for this record

Row Menu > Any of the edit options

clipboard_e9b7745240ad3ebddbdf106cf4a512920.png

Add Adds to this record without opening view/edit page (note, attachment, task, etc.)

Row Menu > Any of the add options

clipboard_e6d53d18e5a13e522fef2e2f48ffcedbc.png

Delete (Single) Deletes this record only

Row Menu > Delete

clipboard_eac88e2627b403a42d135b1c18ee910aa.png

Sort

Clicking the column header once sorts the data in ascending order (low to high, old to new, etc.)

Clicking the column header twice sorts data in descending order (high to low, new to old, etc.)

Clicking the column header three times resets the order to the default when the page loaded

Column header (on-click)

clipboard_eaa9af40c0a531ed462758ee6889ad404.png

Column Header Menu Opens the column actions menu

Column header (on- hover)

clipboard_e383e13027081528c9ee3d52e13aed5fa.png

Pin Column Pins/Un-pins the column from the left or right

Column Header Menu

clipboard_e20f381dc50f9a44efd2e765ac747a305.png

Autosize this Column Adjusts this column width to fit column data

Column Header Menu

clipboard_ed683ccdc4d8e2050c0b678dd1b2f2b04.png

Autosize All Columns Adjusts all column widths to fit column data

Column Header Menu

clipboard_ef326af3699920bcd17f4f454efcc54b9.png

Reset Columns Resets all grid columns to the default when the page loads

Column Header Menu

clipboard_e16e4cac11c09f5efcdc6af2ba837b5b2.png

Filter Adds filter for this column

Column Header Menu

clipboard_e997fc19e53aea9463a05d6979bc2fce1.png

Reset Filter Clears filter for this column

Column Header Menu

clipboard_ec318c8b98ec437c2a3302f7df230b0b6.png

Add/Remove Column Adds or removes columns from the grid

Column Header Menu

clipboard_e6cf4b3c12e9e358e4ecca27af45a639b.png

 

  • Was this article helpful?