Skip to content

Case Study

Highlands Hours

A phone-first clock-in app that replaces a shared spreadsheet for tracking student-athlete study hall hours.

Built for
New Mexico Highlands University
Status
Live
Year
2026
Capabilities
Custom Apps / Automation
Highlands Hours interface

The Problem

Student athletes at New Mexico Highlands University have to log a set number of study hall hours each week. Before this app, they typed their name, arrival time and departure time into a shared document and added up their own totals. Staff then spent hours checking the math, chasing missing entries and reporting to coaches by hand.

The Approach

We aimed for a student experience that's almost too simple to get wrong: sign in, tap Clock In, study, tap Clock Out, see your hours. Everything else, like totals, requirements, reports and corrections, happens on the admin side.

Athlete home screen with weekly progress and a Clock In button
Clocked-in screen with start time and a Clock Out button
My Hours screen with a daily bar chart and session history
The student side: weekly progress, one big button, and a clear history.

How It Works

  • Server-side time. Clock-in and clock-out times come from the server, not the phone, so the records hold up.
  • Weekly requirements. Each sport has its own weekly target, and individual athletes can have overrides. Progress and "behind" status update automatically.
  • Location check. Each clock-in can record where it happened, checked against approved study locations that admins set per team.
  • Coach reports. Admins can email an athlete or team summary for any week to the coach.

Product Experience

The admin dashboard answers the first question at a glance: who is in study hall right now, and who is falling behind.

Admin overview with live counts and a table of athlete hours by sport
The admin overview: live attendance, today's sessions, and every athlete's week.
Athlete detail page with session history and edit controls
An athlete's full session history. Admins can correct any entry, and every correction is logged.
Email hours report form with a preview of the coach email
Weekly reports to coaches, with a preview before sending.

Technical Build

A React, Vite and TypeScript app that installs on a phone like a native app (a progressive web app). Netlify Functions sit between the browser and the database, so the browser never touches the data directly. It's built to grow to more sports, more terms and single sign-on without a rewrite.

Outcome

Live at New Mexico Highlands University since late September 2026, replacing the spreadsheet for the athletics program. Figures in these screenshots are sample data.

Let's Talk

What do you hate doing?

Tell us about the spreadsheet, manual process, disconnected system, repetitive task, or workflow that drives you nuts. We'll start there.

Bring Us a Problem →