Work / Healthcare tracker
The practice had two separate problems that were being handled with the same blunt instrument: a spreadsheet. Referrals were logged manually, with no geographic view. Prospecting for new referral sources meant cross-referencing several directories by hand. Both workflows were slow and error-prone.
The brief was to replace the spreadsheet. What we built was two distinct tools, one web-based and one desktop, that addressed each problem cleanly.
"Two tools. One replaces the spreadsheet for referral tracking. The other replaces a day of manual directory research."
Project summaryA PHP and SQLite web application, deployed behind device-key authentication so only practice devices can access it. Referrals are logged against patient records and plotted on a Leaflet map. The map gives an immediate geographic overview of where referrals originate, which is information the spreadsheet could not surface at all.
The device-key gate avoids the overhead of a full authentication system for a small internal team, while keeping the data inaccessible from outside the practice's known devices.
An Electron application that aggregates prospective referral sources from four data sources: a regulatory directory, a professional association register, OpenStreetMap, and a clipboard smart-paste that handles arbitrary contact-list formats. The smart-paste handles whatever the user copies from any directory, normalising it automatically.
The application includes PIN lock for security, merge-import to de-duplicate across sources, and one-click export to a format the practice already uses. The prospecting step that previously took hours of manual cross-referencing now takes minutes.
Web app and desktop tool in production. The spreadsheet is retired. Referral tracking has geographic context it never had before. Prospecting from four data sources is now a single-application task.
Next: Cinematic brand site