An audit Trinity's staff would actually finish
I built Trinity Hospice a digital version of their rehabilitation audit. Staff used it. The data shaped their wellness strategy.
The situation
Trinity Hospice runs an audit called "How Rehabilitative is Your Hospice?" — a 115-point check across eight areas of care. For years it lived in a spreadsheet. Some teams filled it in. Others didn't. The ones that did often disagreed about what counted as "done," which meant the results weren't consistent enough to base decisions on.
That mattered, because the audit was meant to feed strategy on wellness services. Hard to set direction from data you can't trust.
What I did
I built a focused web app. Not a platform. Staff log in, work through the audit together, and see who else is editing in real time. Each question has four states rather than yes/no, so partial progress shows up properly instead of getting rounded to nothing.
The people running the audit get a live view of who's filled in what, and how well it's been answered. That meant they could spot a team getting stuck, or a section being half-completed across the board, and step in while the audit was still happening. Not after.
The lead clinician gets an admin layer too: user management, an editor for the questionnaire itself so it can change without me, a view across all audits, quality analysis, and an Excel export. Access is controlled at the database level, so admins decide who sees what. Teams can't see each other's data unless an admin says so. The same setup means a different organisation could be set up without their audits ever touching Trinity's.
React, TypeScript and Tailwind on the front. Supabase handles auth, the database, and row-level security on the back. Deployed on Netlify. I prototyped it in a couple of days on bolt.new, then hardened it in Claude Code.
What changed
The beta ran with a real team at Trinity. They completed real audits. The data that came out was good enough to shape Trinity's wellness strategy. Which is what the audit was always meant to do, and what the spreadsheet version never quite managed.
It also changed how the audit got run. With live visibility on progress and quality, the people leading it stopped chasing submissions and started having conversations.
"We are a charity with a tight budget, we make do with what we have. This trial proved what was possible in a short amount of time. It changed the way we engaged with the audit and the data. It was frankly brilliant for creating conversation."
Director · Trinity Hospice
The takeaway
The shape of the tool came from the shape of the job. A small, opinionated app, built in days, got more people completing the audit and produced data clean enough to act on. None of that needed a platform.
Got a job that looks like this?
If you've got a spreadsheet doing the work of an app, let's have a conversation.