Automates attendance tracking and cold-call selection for both T&E and L&C classes.

Set these in Val.town UI (Settings → Environment Variables):

Set in Val.town UI for each cron val. Times are UTC:

Note: Adjust for DST. These are EST (UTC-5). EDT (summer) is UTC-4.

Important: After first push, get the lc-oncall-selection.http.tsx endpoint URL from Val.town UI and update line 10 of lc-oncall-notify.cron.tsx.

POST to post-class-report.http.tsx endpoint with:

curl -X POST "https://sahar--{hash}.web.val.run" \
  -H "Content-Type: application/json" \
  -H "X-API-Key: YOUR_REPORT_API_KEY" \
  -d '{
    "date": "2026-01-12",
    "class_type": "te",
    "cold_calls": [
      {"student_name": "Alice Adams", "result": "completed", "performance": "great"},
      {"student_name": "Bob Baker", "result": "absent"},
      {"student_name": "Carol Chen", "result": "refused"}
    ],
    "absences": ["David Davis"]
  }'

Fields:

• date: Class date (YYYY-MM-DD)
• class_type: "te" or "lc"
• cold_calls: Array of students called on
  • result: "completed" | "absent" | "refused"
  • performance: "great" | "normal" | "bad" (only for completed)
• absences: Other absent students (not on on-call list)

Response:

{
  "success": true,
  "date": "2026-01-12",
  "cold_calls_logged": 3,
  "absences_logged": 1,
  "unprepared_processed": 0,
  "alerts_sent": []
}

Automatic email alerts at thresholds:

• 3 absences → Contact dean + student
• 5 concerning events → Contact student

Concerning events = absent + unprepared + refused + bad performance.

Uses Google Sheet with tabs:

Shared:

• Form Responses 1 - Student self-reports (form-owned, read-only)
• Cold Call Log - Audit trail of actual cold calls

T&E:

• T&E Roster - Student list + cumulative tracking (columns: student_name, last_name, pool, cold_call_count, last_called, absences, concerning_events)
• T&E On-Call - Daily on-call selections (for idempotency)

L&C:

• L&C Roster - Student list + cumulative tracking (same columns, minus pool)
• L&C Assignments - Preset syllabus schedule (columns: date, student_name)
• L&C On-Call - Daily on-call cache (for idempotency)

1. Create L&C Roster tab with columns: student_name, last_name, cold_call_count, last_called, absences, concerning_events
2. Create L&C Assignments tab with columns: date, student_name
3. Populate L&C Assignments with syllabus data (one row per student per date)

Example L&C Assignments: