Weekly email: instructors and trainers who completed a level
Shipped 2026-11-03
Operations asked for the level advancements report by email every Monday before 5am (TUN-914). It is the first scheduled report, so it is built as a general mechanism rather than a one-off.
What arrives
Every Monday at midnight PST, last Monday to Sunday’s results: a table in the email, the same rows as a CSV attachment, and an Open in admin button that opens the report on that week. A week with no results still sends, saying so, so a quiet week can be told apart from a broken job.
Recipients are managed in admin under Tools › Scheduled Emails, which also shows the last few sends and any errors. To start with they are Alex and Rusty, for a two-week review.
How it works
A new daily job, scheduled_reports, works out each report’s last complete
period and sends it if it has not been sent already. The period is claimed in
scheduled_report_runs before sending, so retries and manual triggers never
send twice, and a failed or interrupted send is retried the next day. Rules are on
Reports and scheduled emails; operations on the
cron jobs page.
Adding another scheduled report is one entry in the registry plus its recipients. Weekly and monthly cadences are supported.
Also
- In the CSV, a cell starting with
=,+,-or@is prefixed with'so spreadsheets do not run member-entered names as formulas. - The level advancements page accepts
?from=and?to=. - The shared email sender can render without sending and attach in-memory files.