Skip to content
Back to research & projects
Web appLive2026

Correspondence Tracker

A web-based correspondence management system for organizing, tracking, and reviewing project letters and communication history.

Fig. 01 · Schematic

Overview

A standalone web app for logging and browsing project correspondence on the Tamakoshi V Hydroelectric Project. The letter register lives in shared cloud storage and is read and written directly over WebDAV, so every device sees the same live record without a manual upload step.

Approach

A static HTML and JavaScript front end backed by Node.js serverless functions on Vercel. Sessions use signed tokens, and user accounts are kept in Upstash Redis, with a local JSON fallback so every feature can be developed without a database.

Features

  • Role-based access: admins add, edit and delete letters and manage logins; department viewers get a read-only view of the letters tagged to their department.
  • New letters typed into the master Excel register appear on the next load, overlaid onto the historical record.
  • Letter PDFs are linked automatically by letter number and previewed in the app.
  • Admin page for creating and managing user accounts.