Before, data records in SchoolFront were generally stored in static grids with some ability to search/sort and pagination controls. Now data records in most parts of the system are in highly searchable, sortable, and filterable data grids which can be exported into Microsoft Excel™ and/or save the display as a personal "view."

Sort and Filter Grid Content

Data in grid columns can be sorted into ascending and descending order simply by clicking on the column header. Filters can be applied to one or more columns in a data grid to reduce data to only that which you wish to see. Column filters in a given data grid depend on the type of data in each column. The filter options for data types are detailed below. Data types include:

• Boolean
• Date / Time
• Numeric
• Text

Save & Repeatedly Use Personalized Grid "Views"

The term "view" refers to one or more filters and / or sorts have been applied to refine the records displayed in a grid using criteria specified by the user. It can take time to apply the necessary filters and sorts required to get to a certain view, so if you have views that you use frequently, you can save them rather than having to reapply your filters and sorts over and over again. Saved views can often be used in place of reports.

For more information about data grids and ad-hoc "reporting" in SchoolFront, click here.