Skis per Year

<aside> 💡

How to use!

To add a new ski day:

1. Go to the correct database: I split mine up by season, so this year I’ll add to 2025-26 Season
2. click New Page
   1. add a Ski name (I usually name mine after my Strava titles)
   2. select the Type - you must add a Type for it to show up in Skis per Year
   3. add the date
3. The page with auto-populate into the Skis per Year database
   1. This acts as the dashboard to show you your ski days per year over however many years you have entered

Add a new ski type:

1. Go toSkis per Year database
2. New page:
   1. name it (ex. Telemark)
   2. add emoji - optional
3. It will auto-populate under the ski type column on all connected databases </aside>

<aside> 💡

Notes on the Template

• The Sum on the Skis per Year database shows the total number of ski activities you added to the season Database (ex. 2025-26 Season). If there are multiple on one date, it will include all of them.
  • To see how many unique days you skied, look at the number below the Date column on the season database (ex. 2025-26 Season) - it will say “Unique #”
• Sort is on for the Date column, new pages will automatically sort in ascending order once the Date field is entered
  • to turn this off: click the up/down arrow icon (sort) on upper right of the database, click the X next to the Date - Ascending sort. You can also add or edit the sort here.
• On the ski type column: you can select multiple ski types, but that will double count the activity in the Skis per Year database. I only select one. </aside>

<aside> 💡

To add a new ski season database

1. Click the group of 6 dots on the left of the most recent database, select Duplicate > Duplicate without Content
2. Wait for the database to load - this could take a minute!
3. Rename the database
   1. ex. change to 2026-27 Season
4. On the Ski Type column: click Edit Property > Turn Two-way relation on
   1. rename the relation, I do 2026-27ski
5. On Skis per Year database
   1. Settings > Edit Properties > Add New Property > Rollup
   2. Relation: select the relation you just renamed in step 4 (ex. 2026-27ski)
   3. Target Property: Ski
   4. Calculate > Count > Count all
   5. Rename Rollup property (I do 2026-27) </aside>

2025-26 Season

2024-25 Season

2023-24 Season