Work with Grids (Tables) in Jackrabbit

Throughout Jackrabbit you will see grids, sometimes referred to as tables. These grids display the data you have entered into your Jackrabbit system. The grids are powerful - allowing you to group, sort, filter for specific information, and more.  Note: Not all features are available in every grid throughout Jackrabbit.

Expand each section below to see a sample grid and to review how to use grids.

View a Sample Grid

1 - Breadcrumb Bar displays the currently selected filters.
2 - Drag and drop a Column Header into the Grouping Bar to group results.
3 - Click a Row Menu to open action items for the selected row.
4 - 
Page number displays up to 250 items per page.
5 - Filters have been applied when the column menu changes to blue.
6 - Column Menu sorts and/or filters the data in a column (options in this menu vary depending on the type of grid).
7 - Manage Certifications opens the Drop-down List Editor to edit (for the Certifications page only).

8 - Send Message and Add New icons (depending on the page you are on these may not be displayed).
9 - Slider shows more columns in the grid.

Group Your Data

Drag and drop column headers to the grouping bar to create groups within your report. 

  • Click on the column title in the grouping bar to re-sort the column in ascending or descending order.
  • When multiple columns are added to the grouping bar, the first column on the left is the first level of grouping. The second column added to the grouping bar will group the rows within the first column, etc. 
  • Click and drag the column headers left or right within the grouping bar to change the order. 
  • Use the X  in the column header to clear a column from the grouping bar.

Filter Data in the Grid

There are multiple ways you can sort and filter data in a grid. Select the sorting options that work best for you:

You can reorder the columns in a grid by clicking and dragging them to the spots you want them in. Double arrowheads indicate where the column will drop (behind the arrowheads).

Click on the column header to sort in ascending or descending order. An arrow displays to show the current sorting order; no arrow indicates that no sorting has been done on the column. 

Use the column menu to access the sorting options for each column.
  • Ascending order
  • Descending order
Multi-sort columns in the grid, for example:
  • Click the Family column header to sort the column in ascending order A-Z (as shown above). An up arrow and the number 1 indicates this is the 1st column in the sort.
  • Next, click the Status column header and all the active families will be listed first in the grid. An up arrow and the number 2 indicates this is the 2nd column in the sort.
  • The column width expands to show the sorting information.
  • Click Columns in the menu to select the columns you would like to view in your grid. 
  • Filter (available in most grids) - use the filter to drill-down further into your column data. 
  • More than one column can be filtered at a time. 
  • There are several types of column filters. Some filtering will list all values in the column with check boxes and a search field while other filters allow you to define the filter with options such as "Is equal to" or "Contains".
  • Applied filters display in the Breadcrumb Bar.
  • You can lock a column from a column menu  so that when you scroll horizontally, the column will always remain in the display while the remainder of the columns scroll.

    Use the horizontal scroll bar (lower right when visible) to move the grid from left to right.

Take a Single Action

Each grid is designed to provide ease of use and to simplify different actions you may want to take. These single actions allow you to edit a single row, delete a single row, add additional data for the selected row, and link to take additional actions.

Click on the Row Menu to work with individual rows in the grid. Depending on which page you are on in Jackrabbit, you will see different options:
  • Edit - click on the link to open the content in the row and make changes.
  • Delete - remove a row from that grid.
  • Additional actions - click on the row menu to see the other action options.

Note: the row menu actions offered will vary between the different grids in Jackrabbit.

Click the Add New icon to open a pop-up window to add new data. This icon is visible depending on which grid you are viewing, for example, on the Staff Certifications page Add New Certificate window opens or on the All Families page an Add New Family window opens. 

If any rows are selected in the grid, an Add New icon will not be visible.

Perform a Mass Action

Mass actions allow you to work with multiple rows in the grid at one time. Note: Each page in a grid displays a maximum of 250 rows of data.  

Click Send Message to open the email editor and send an email.

  • Select the check box for the rows you want included in the email. You can select individual rows across multiple pages or select the check box in the column header to send an email to all rows currently displayed on the page (max 250/page). 
  • To email ALL rows on ALL pages, leave the 1st column check boxes empty. All rows will be included, and you can clear rows in the email preview if needed.
When one or more rows in a grid are selected, use the More icon to access actions that can be taken with multiple records at once. The options available will differ between grids, e.g., in All Families you can update Family Fixed Fees, Family Discounts, Clear UDF Answers, and more.

  • Select the check box for the rows you want included in mass action. You can select individual rows across multiple pages or select the check box in the column header to select all rows currently displayed on the page (max 250/page).

Data Visuals

Some of the grids in Jackrabbit have visual elements, referred to as data visuals. Click on the sections of the visual to see the information populate in the grid results. 

In addition, there is a filter drawer to make additional selections that narrow down results in the grid. Within the filter drawer, the criteria are organized into sections. Use the search field at the top of the drawer to locate a specific criteria and be taken directly to the matching filter. Use the Expand All link to open all sections or the arrow next to each section header to open individual sections. Click the Apply button to filter the data in your grid using the criteria you selected; these filters will display in the breadcrumb bar. 

  • Save your filtered data as a Favorite. Once filters are selected, click the Save as favorite (icon), enter a favorite name, choose if you want to make the favorite a default view, and decide if you want to share with your team. Your filtered data, column width, column locked positions are all saved. Click Save.
  • Load a Favorite by clicking on the Favorites (icon), select your saved favorite from the drop-down list and click Load. The grid populates the data and the breadcrumbs indicate the selected filters.

Refer to Work with All Families - View, Search, and Take Action and Work with All Students - View, Search, and Take Action for more details on the All Families and All Students data visuals.