All projects

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
  • Email
3

languages

83

automated tests

0

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