Skip to main content

Data Grids - Functionality Overview

Dylan B.
  • Updated

Throughout the system you will see information in the SchoolFront Main Window displayed in data grids. Data grids allow you to browse records, search records, and filter records upon command. After you sort and filter records in a data grid, you can export the data into Microsoft Excel™ and/or save the display as a personal "view" which you can use to recall the display you configured whenever you need it.

Applicable Roles

  • All SchoolFront Roles

Additional Resources

For reference on the multiple ways to use Data Grids, please see the following articles:

Anatomy of Data Grids

Data Grid.png
Example of the "Open Job Postings" Data Grid

Browsing Records in the Data Grid

Data grids usually contain many records, and each record contains numerous amounts of data. The volume of information is usually too large to completely fit on your computer screen. 

To browse through all records in the data grid, you can navigate using the scroll bars on the right-side (to go up and down) and bottom of the grid (to go left and right):

Data Grid1.png

Pages Allow You to See More Records

To browse multiple pages of records, choose a page number from the page dropdown in the bottom left of the grid. You can also go to the next page by pressing the "Next" button:

Data Grid Pages.png

Expand or Minimize Display

Click the arrows to adjust the view of the data displayed on your screen:

Data Grid2a.png

When a line item in a grid has been selected, the resulting data is then displayed in the lower portion of your screen. Utilizing these arrows can assist with viewing and editing full pages of data at once:

Data Grid2x.png
Data Grid2b.png

How do the Checkboxes work?

The grid will keep a running count of how many boxes are selected, to the right of the page selection options. 

Data Grid2.png

  • If one or multiple boxes are checked, any button you press above the grid will apply to all selected records.
    • Number of selected items will display.
  • If zero records are selected, any button you press above the grid will apply to all selected records.
    • Number of selected items will not display.
  • If any number of records are selected, changed, and disappear from your grid they will still show as selected. Press the "Clear All" button above the grid to clear out hidden selected records.
    • Example: I filter a grid to have 100 records, and I change 50 of them. The 50 I changed are technically still on this grid but no longer fit my filters. The grid still shows "50 Selected". The way to remedy this would be to press the "Clear All" button.

 

Related articles