Behavior Referral Tracker
A free, role-based behavior referral system for K-12 schools — built to run entirely inside your district's own Google Workspace, with no new vendor, no hosting cost, and no student demographic data ever stored in it.
This started as a spreadsheet-and-forms tool for tracking behavior referrals in my own district. It's since been rebuilt from the ground up into a proper multi-user web app: teachers submit referrals in a couple of clicks, building admins assign them to counselors, and everyone gets closed-loop email updates instead of a referral disappearing into a spreadsheet no one revisits.
What it does
- Role-based access — teachers, counselors, building admins, and a district admin each see only what they should, enforced by the app itself rather than by sharing permissions on a spreadsheet.
- A full referral workflow — submit, assign, and close cases, with email notifications at each step so nothing gets dropped.
- An Analytics tab — filterable charts by location, period/activity, time of day, day of week, grade, and referral type, so patterns (where, when, and during what) are actually visible instead of buried in rows.
- Privacy by design — no demographic data is ever stored in the tool. A district admin can optionally join in a separate SIS export live, at report time, for equity reporting — and nothing from it is saved afterward.
- Free and self-hosted — it runs as a Google Apps Script project inside your own district's Google account. There's no central server, no subscription, and your student data never leaves your own Workspace.
Get it
The full project — setup instructions, every file, and notes on customizing it for your building — is on GitHub. Deployment takes about 15 minutes and doesn't require coding experience; you're mostly pasting files into the Apps Script editor and following the README.