So I made some updates to the logs being used in production. You can check out the earlier development here and here. The problem, if someone doesn’t record reclaim sessions all week, we find out Friday when the weekly report runs. By then the week is gone. Accountability lived in the log but nothing was added until it was too late to do anything about it. So I started moving accountability to the point of use.

Moving Accountability to the Point of Use

The dark room form now shows a live weekly progress banner. It pulls shift task data from the backend through a new endpoint and refreshes every time someone submits. Reclaim session count, hours logged, right there on the form. A message notifies the employee and changes by day, a gentle nudge Monday, an actual warning by Friday. The person doing the work sees where they stand everyday, not in a report seven days later.

Capping the Impossible

Shift coverage tracking is now on the weekly and monthly reports, what percentage of an 8-hour shift actually shows up in the logs. The first pass returned rates like 198% and 109%. That’s a timer left running, not a real number. A minute cap per entry filters those out. The monthly report also got a shift task activity table: days and hours per task across four weeks, trend arrows, and a reclaim frequency warning when the cadence slips.

Every fix here is the same move. Catch it where the work happens, not in the report after. The system was never short on data. It was short on showing the truth at the moment it mattered.

Tools used:

• Google Apps Script (doGet endpoint, live progress banner, report and validation logic)
• Google Sheets (dark room logs, weekly/monthly/quarterly reports, TrendReports script)
• Claude (script writing, order-number normalization, form validation rules)