Filter (Group) Class Listings Tables

Objective


Filter a Class Listings Table to display specific groups of classes.

Solution


Starting with the basic Class Listing Table, use filtering parameters to display only the classes you want in a Class Listings Table, such as classes from a specific category, session, location, or room.

Add one or more parameters to the end of your Class Listings Table code or direct link.

How Filtering Works

To filter a Class Listing Table, add one or more parameters to your basic table code or link.

A parameter includes:

  • A variable
  • A value 
  • An equals sign (=) between them

Example: Cat1=Ballet

Add parameters to the end of the basic Class Listing Table code using an ampersand symbol (&). To use multiple parameters, separate each one with an ampersand.

Filtering Variables

The filtering variables below can be used to control which classes appear in a table. The value for each parameter is based on your own Jackrabbit data, such as session names, room names, or category codes.

Variable Values (where to find in Jackrabbit)
Cat1 Gear (icon) > Settings > General > Drop-down Lists (left menu) > Class (section) > Category 1 drop-down values
Cat2 and Cat3 Gear (icon) > Settings > General > Drop-down Lists (left menu) > Class (section) > Category 2 and Category 3 drop-down values
ClassDays Fixed values: Mon Tue Wed Thu Fri Sat Sun
Gender Gear (icon) > Settings > General > Drop-down Lists (left menu) > Student (section) > Gender drop-down values
InstructorID Staff (menu) > Active Staff > Individual Staff record > Id: ###### (auto-generated number bottom left of each page in the Staff record)
Loc Gear (icon) > Settings > General > Business Locations (left menu) > Location Code
Room Gear (icon) > Settings > General > Drop-down Lists (left menu) > Class (section) > Room drop-down values
Session Gear (icon) > Settings > General > Drop-down Lists (left menu) > Class (section) > Session drop-down values

Example

Customize the basic Class Listings table for Organization ID XXXXXX to show only Ballet (Cat1) classes at the Main Location (Loc). The parameters here would be Cat1=Ballet and  Loc=Main.

Example JavaScript

<script type="text/javascript" src="https://app.jackrabbitclass.com/jr3.0/Openings/OpeningsJS?OrgID=XXXXXX&Cat1=Ballet&Loc=Main"></script>

Example Direct URL

https://app.jackrabbitclass.com/jr3.0/Openings/OpeningsDirect?OrgID=XXXXXX&Cat1=Ballet&Loc=Main

Rules

  • With the exception of the Category 1, 2, and 3 variables, only one value can be added to each parameter.
    • Multiple Category 1, 2, & 3 values can be used with a vertical line ( | ) separating them. 
  • Separate multiple parameters with an ampersand (&).
  • A variable can be used only once in a table code, but multiple variables can be combined.

ℹ️Tip: To preview your changes while building your Class Listing Tables, open your basic table URL in a browser window. Add parameters and refresh the page to see the updated results.
 

 

Was this article helpful?
0 out of 0 found this helpful