Case study · ITV Formentera · Consell Insular · 2026
Vehicle inspection appointments without queues or phone calls
Public appointment booking system for the vehicle inspection centre, with PIN verification, PDF confirmation and a dashboard for the centre's team.
- Bookings
- Back office
languages
automated tests
double bookings, by design
The challenge
Appointments were handled by phone and by hand, with lost slots, double bookings and no reminders. It needed a simple website for citizens and a nimble tool for the centre's staff, with a guarantee that two people could never take the same slot.
The solution
A Node.js application on Cloud Run with Firestore. Every time slot has its own occupancy document and bookings are made inside a transaction, which rules out double bookings even under simultaneous load. Citizens confirm with a PIN sent by email, download their PDF confirmation and can manage their appointments. The internal dashboard shows the daily and weekly grid and supports blocking, a blacklist and CSV export. Cloud Scheduler triggers reminders and expiries, and the operations, restore and security documentation lets the Consell run the service independently.
Project highlights
- 01
No double bookings
Firestore transactions and an automated concurrency test.
- 02
Practical security
Helmet, rate limiting, JWT, bcrypt, Secret Manager and data encryption.
- 03
Backups and recovery
Seven-day point-in-time recovery plus daily and weekly exports to Cloud Storage with alerts.
- 04
Measurable quality
83 tests, a 24-check smoke test on staging and a documented, phased handover.
Technology
- Node.js
- Express
- Firestore
- Cloud Run
- Cloud Scheduler
- Secret Manager
- nodemailer
- pdfkit
- helmet
- JWT
- bcrypt
- Cloud Monitoring
- node --test
Need something similar?
Let's talk about your project