Display Results with GravityView
Back to: Host a Virtual 5K with Gravity Forms
License Note
For this lesson you will need a GravityView All Access License or a GravityView Core + Extensions license and a Math by GravityView license.
To display results on your website, we’ll create a View similar to the one in the last lesson.
Start by creating a New View, name it 5k Results, and choose the Data Tables View type.
Clear the Above Entries Widget fields and continue to the Entries Fields section. Here select the fields that you want to display for the results. For a pretty standard results display, I’ve added the following fields:
- Name
- Gender
- Age
- Time
Age is entered as a Custom Content fields using gv_math just like in the last lesson.
To identify the place ranking for each runner, let’s add another Custom Content field and drag it to the top.
In the Custom Content field, enter {sequence} and add a custom label of Place.
This will number the entries with 1 for the first entry, 2 for the second and so on. We will sort the entries by time so that the first entry is the first place runner. We can also filter the entries to show the results by category.
Clear the Below Entries Widgets, then continue on to the View Settings.
Ensure that “Show only approved entries” is checked. You can choose whether to also check “Show all entries to administrators.”
Next click on the Filter & Sort tab. Sort by the Time field in Ascending order. It should look like this:
Finally, you can use the Advanced Filter to show results in groups. For example, to show results for 30-40 year old females, you would set the following parameters:
Gender is Female
AND
Age on Date of Race is 30 OR Age on Date of Race greater than 30
AND
Age on Date of Race less than 40
You can easily duplicate your View and change the Advanced Filter parameters to create a View for each group in your race. See our course Using Advanced Filters to Easily Display Subsets of Your View for details on how to do this.
Once you’ve finished setting up your Views, grab the Embed Shortcode and embed it on your results page. You can insert multiple GravityView shortcodes on one page to display all of your groups on the same page.
The final result looks like this (without sorting by gender or age):
