What’s being built
Read-only view for Tauquil, Adam, and Anat. Every open piece of work in one place.
Full detail (comments, acceptance criteria, history) lives on GitHub Issues — ask Trevor for access.
Status as of 2026-05-12. V2.2.20 shipped — dashboard locked at this point for FotA Summer 2026. Trevor’s words: “The work is the work now. Dev ideas stay hidden on the dashboard but logged in the git. Only a few tweaks to make as data gets cleaned but this is the rolling document until FotA ends.”
V2.1 shipped 2026-05-08 (PM-tool pivot). V2.2 followed 2026-05-09. Five days of operational polish to 2026-05-12 produced V2.2.20 as the new lock point. Same freeze rule: bug fixes only after this.
V2.2.6 through V2.2.20 landed: What is FotA narrative page (anchored to the Jan 18 vision/mission refresh) + Data Pack page (Appendix-A tables inlined) + strategy critique widget (side rail on What is FotA, submissions land in gantt with status='strategy') + parser fix (ENG/MAN cells now count as paying weeks; previously silently zeroed K1+K2) + Mandarin Immersion sub-product rendered on every ELC audience cell with MAN students + per-column product routing (K1’s PE49 columns now route to Thonglor PEs, not ELC) + hygiene loud-fail email (mismatch cross-check against row-76 totals, Thursday alert to trevorc@elc.ac.th) + status chips open to all domain users (anyone can close their own tasks; other fields still editor-gated) + calendar-week ‘Done this week’ (Mon BKK boundary; previous rolling 7-day window dropped) + per-person desk done tile + collapsed list + email push includes Done This Week + modal date picker (replaces unreliable opacity-0 overlay) + 2025 PE audience baselines wired (90 Internal / 4 Ext-Local / 6 Ext-Overseas).
Going forward: dashboard is frozen at v2.2.20. Neung on data hygiene, PE Heads on lead conversion, Payal + Heather on educational experience, April + Mark on Dove, Trevor on cross-team orchestration + daily pushes. Bug-fix-only ship cadence. Strategy + data-pack copy edits welcome (text files). New surfaces or features go to GitHub issues (Tr3v0r86/fota-ops/issues) for the post-summer-2026 cycle.
Inaugural still 2026-08-07.
Phase 2 + Phase 3 — Complete ✓
V2 dashboard is the operating surface. Apps Script reads fota_master every Wednesday night and Thursday morning, rolls up enrollment numbers, and serves them via the /exec web app. Triggers are running. Domain auth gates access to elc.ac.th accounts.
What landed in V2 (2026-05-04 → 2026-05-07):
- Audience grid — 4 products × 3 audiences (Internal / External-Local / External-Overseas), with Dove + Samakee shown as TBD pending segment locks.
- 2025 baselines wired — ELC: Internal 233 / Local 38 / Overseas 22 (audience-true from Mark + Neung’s INTL backfill, completed 2026-05-06). PE39: aggregate 43 with caveat (children or weeks unconfirmed). Samakee: no data yet.
- Phase-aware “vs ‘25” chip — hidden during build phase (since 2025 numbers are end-state, not pace), restored at inaugural. See parking-lot IDEA-17 for the full reasoning.
- +50% target (“The Bar”) — masthead now shows current ELC paying-weeks vs 440 target with progress bar.
- Activity panel — dept × time grid, drag-to-reassign owner, inline title + due-date editing, audit log per write.
- YouSection (“What needs you”) — collapsible per-person desk with overdue / due-this-week stats.
- Past-due section — fully editable rows (title, due date, owner — owner click opens picker modal).
- Email-PDF + Todoist dump — per-user personal digest. Todoist token-based, one-shot, no two-way sync.
- Idea capture — “Send to gantt” widget creates
status: idearows ingantt_master. - Retrospective — header-aware parser pulls Mark’s “Changes from 2025 to 2027” sheet into a 2025/2026/2027 column view.
- Schema renames landed —
counterparty → others(#27),PE39label →Thonglor PEs(#29). - Domain auth —
webapp.access: DOMAINin manifest. Dropping the?as=emailURL preview hack now that real Session identity is available. - clasp deploy as default — Workspace admin policy blocks the editor’s deploy dialog;
clasp deploy -i <id>is the canonical path.
Things still waiting on a person
These are blocked — someone specific needs to decide or act before the system is fully complete.
| # | What’s needed | Who | By when |
|---|---|---|---|
| #3 | Confirm Neung’s INTL Y/N values (Gantt T-20260504-0028) — backfill is done; awaiting verification sign-off | Neung | 2026-05-07 |
| #5 | Lock the Dove audience list, capacity, and external-yes-or-no | April-led, Sarah supporting | TBD |
| #6 | _hygiene_history write of 2025 rows for schema consistency — overlay constant approach is live, but issue still tracks the formal write |
Trevor decides path A/B in comments | TBD |
| #7 | Confirm whether PE doc (Sumeet/Amanda) or fota_master (Neung) is PE enrollment source-of-truth | Trevor + Sumeet/Amanda + Neung | TBD |
| #8 | Reconcile Mel’s “Early FotA Interest” pre-registration list into fota_master | Sarah | TBD |
| #9 | Manually retag 3 rows in live gantt_master to Cross-Cutting/All | Trevor | Anytime |
| #10 | Confirm what P2 T (teacher child) and P2 S (scholarship child) mean operationally | Adam | TBD |
| #19 | Acceptance test: Neung hand-counts ELC-Internal weeks on 2026-05-23; parser must match exactly | Neung | 2026-05-23 |
| #27 | Manual gantt_master Sheet header rename: counterparty → others. Schema/code already done. After this, the apps-script transitional fallback can be dropped |
Trevor | Anytime |
| #28 | Dove: expand from placeholder to 3 full audience cells (once April locks her segment list) | April → Trevor | Post #5 |
| #30 | Define how the Gantt phases map to the weekly calendar | Trevor | TBD |
| #31 | Nail exact session dates across all products → single canonical date table | Trevor | TBD |
| #34 | Gantt live-sheet tidy: hide internal columns, add timeline tab | Trevor | TBD |
| #44 | Pre-registration tab parser → ELC-External-* — blocked on Neung cleanup of Country / Week / Class column hygiene + dedup-with-grade-tabs strategy | Neung | TBD |
| #47 | V2 PRD — close once Dove unlocks (#5). Implementation shipped to V2 deployment | Trevor | Post #5 |
| #54 | OAuth + YouSection + Email-PDF + BacklogIdeas wiring — landed in V2 launch 2026-05-07 | Trevor | Done — close after meeting feedback |
Closed today (2026-05-07)
- #29 — Schema rename: PE39 label → Thonglor PEs (label-only, key stays PE39 per 2026-05-04 grill scope reduction)
- #53 — Historical ELC data seeded → fully superseded by 2026-05-06 audience-split landing
Enhancements — queued
These don’t block V2. Ready when the team is.
| # | What it adds | Status |
|---|---|---|
| #37 | Dashboard layout: left-to-right triptych — “last week · where we are · next week” | Ready to build |
| #38 | Dashboard: who has the most open tasks this week + who closed the most | Ready to build |
| #39 | Dashboard: overdue tasks list — framed supportively (partly shipped — full surface still pending) | Partial — full surface queued |
| #41 | Automated reminder email 24h before ops sync and SLT meeting | Ready to build (deferred from V2 per #47 grill) |
| #52 | Activity filter chip — sheet/dash/all (FACELIFT-C) | Ready to build |
| #55 | Refresh model — manual ↻ button + freshness indicator | Ready to build |
| #56 | Audit log surfacing — per-task hover tooltip + SyncHealthSection real | Ready to build |
| #57 | Mobile responsive cut — phones first | Ready to build |
| #58 | Wed-meeting helper panel — rows added since last Wed needing enrichment | Ready to build |
Parking lot (post-V2 design questions)
Tracked in docs/parking-lot.md. Notable open items:
- IDEA-17 —
deltaLastYearchip semantic; current build-phase suppression is a stop-gap. Decision before SLT inaugural 2026-08-07. - IDEA-18 — per-user / per-role access gating beyond domain restriction. Server-side allowlist preferred (mirrors EDITOR_EMAILS pattern).
Phase 4 — longer horizon
Post-MVP. Not blocking anything this summer.
| # | What it does |
|---|---|
| #1 | Phase 2 PRD — the full spec the build tracked against |
| #32 | Two-way sync: extended write-back from dashboard (status, notes, etc.) |
| #33 | Per-user Todoist integration — V2 ships a one-shot dump (token-paste, push to Inbox); future = OAuth + persistent sync |
Last updated: 2026-05-12 · V2.2.20 lock · Back to overview