Case study · ITV Formentera · Consell Insular · 2026
Developed as an employee of the Consell Insular de Formentera. The platform is owned by the Consell.
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