Low-Cost Web App for a Water Utility: Lead Line Replacement Tracking at 80% Lower Cost
A React.js tracking app for a public water utility’s lead line replacement program, using Google Sheets and Google Drive as the backend. It cost 80% less than a traditional backend and gives staff and contractors real-time progress.
- Lower cost than a traditional backend
- 80%
- Installation tracking for staff & contractors
- Real-time
- From brief to working solution
- 2 mo
The challenge
Where they were stuck
The Passaic Valley Water Commission needed to track installations for its lead line replacement program across staff and contractors.
A conventional build with a dedicated backend and database would have cost more and taken longer than the program’s budget allowed.
The solution
What we built
We built a React.js web app that uses Google Sheets and Google Drive as its backend through their APIs. Staff and contractors record and follow installations in real time using tools the team already knew. There was no new server or database to buy, host or maintain.
- 01
Serverless by design
Google Sheets and Drive APIs replaced a dedicated backend and database.
- 02
React.js front end
A simple interface for staff and contractors in the field.
- 03
Real-time tracking
Everyone sees installation progress as it happens.
The results
What changed
- Built at 80% lower cost than a traditional backend
- Real-time installation tracking for staff and contractors
- Delivered quickly and within the program’s budget
More case studies
View all
80%faster report generationUPMC · SBS Step By Step Hip & Knee · Healthcare
AI Healthcare Platform Development: 80% Faster Report Generation for UPMC
A HIPAA-compliant clinical platform, built with UPMC, that uses AI to analyze hip and knee X-rays and turns the findings into patient-friendly reports. Clinicians now produce those reports 80% faster.
- AI & Healthcare
- Web Development
2Verizon brands localized: Wireless & FiosVerizon Wireless / Fios · Telecommunications
Multilingual Website & CMS Development: Chinese-Language Sites for Verizon Wireless and Fios
In-language Chinese websites for Verizon Wireless and Verizon Fios customers, built from user research through to launch. A custom CMS lets Verizon’s marketing team publish landing pages, sliders and promotional banners themselves.
- Web Development
Want results like these?
Tell us where you want to grow. We will review your site, your stack and your goals, then send a clear plan with no obligation.