Field Operations · Community Product
Bakery Live Tracker Building What Matters
How I turned a real-world community pain point into a working, AI-augmented field-operations platform in record time.
Password: 8821
The Spark
Product Discovery in a Village
A mobile B2B bakery truck is a beloved local service — but customers never knew exactly when it would arrive. Missed pre-orders, wasted trips, and people waiting in the cold became a recurring frustration.
The goal was never a "pretty website." It was a system that helps the business run more efficiently and serves the community with meaningful, timely information.
Designer as Builder
The AI-Augmented Pipeline
Google Stitch → MCP → Cursor IDE allowed a single designer to move from concept to production-ready UI in days — not months.
The honest twist: AI generates beautiful components, but not system integration. The real engineering win was merging static Stitch output into a working logic layer — with custom sandbox discipline via .stitch-preview — so experiments never polluted production.
"AI accelerates the surface. Architecture, state, and edge cases still need a builder who owns the system."
For Engineering Leads
Deep-Dive Architecture
Production decisions that survived real field conditions — not demo-day polish.
Serverless Field-Ops on Vercel expand_more
Dual-Layout System expand_more
Spreadsheet-Native CMS expand_more
The GPS Pipeline expand_more
Results
Metrics & Impact
~2,500
Lines of production UI code
3
Languages (UI + Push)
$0
Infrastructure cost
HU / DE / EN supported across UI and push notifications. Powered by Vercel Serverless and Google Apps Script.
Product Demos
See It in Action
Four focused screen recordings — one flow at a time, from the live app.
01 · GPS
Live GPS & Schedule
The van's real position runs in parallel with Google Maps — alongside the actual route schedule, so customers see where the truck is and when it will arrive.
02 · Notification
Arrival Notifications
One tap to subscribe. When the van enters a town, subscribers get a push alert — no app store, no manual refresh.
03 · Product List
Sheet-Native Product Names
The client edits product names directly in a Google Drive spreadsheet. Changes sync to the live site — no custom admin panel, no training.
04 · Stock
Driver Stock Control
From a PIN-protected driver page, sold items are logged with +/− controls. The sheet updates instantly — and quantities on the public page change in real time.
Built for the Community
This project is proof that the best portfolio work solves real problems — with speed, restraint, and architecture that holds up in the field.