Facility Services built a certification expiry alerter

“It's only employee data.”— Plant Manager

Reason:

Allegedly because the documentation starts with "TODO". With 34 users and zero documentation.

Built by:

Tobias, a warehouse supervisor

Build time:

an afternoon, mostly

Built with:

Google Apps Script

Database:

Teams chat history

Authentication:

the JWT secret is "changeme"

Deployment:

running on localhost through a tunnel

Responsible:

whoever happens to be on call

Documentation:

a diagram on a whiteboard, photographed, then deleted

Security situation:

production secrets are in .env.example

Future disaster:

It will stop working after someone renames a column.

Age: 1.9 years · originally expected to last 2 months · 5 owners so far · last meaningful change 210 days ago

Rated rare mostly because: 478 users, €221k per year, 30% chance of becoming business critical.