Schedule grid — period / filters / live totals

No precomputed totals exist upstream, so totals are aggregated right here, from the schedule-db rows for the selected period (not a single Coda formula — client-side aggregation). Period is currently Aug 20 – Sep 19, 2026; "today" in this demo is Aug 29 (in production this is just new Date()).

Hide past days

Filter by team:

Filter by role (has at least one such shift in view):

Role → text color

Shift type → background color

Daily coverage

Also computed on the fly, over whatever employees + dates are currently visible (team and role filters apply here too).

Role filter now checks actual shifts in the currently visible date range (schedule-db rows), not a static capability list — "show employees who have at least one shift with this role in view". Team filter checks the TM field. Change either interpretation and I'll rewire the two functions (teamVisible / employeeHasRoleInView) accordingly.