All projects

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