✓ Report Submitted

${message || \"Your post-class report has been recorded.\"}

\n ${hasFuzzy ? `\n

ℹ️ Fuzzy Matches (please verify)

These names were close but not exact matches:

\"${m.input}\" → ${m.matched}

If any match is wrong, edit the roster directly to fix the counts.

\n ` : \"\"}\n ${hasUnmatched ? `\n

⚠️ Names Not Found

The following names were NOT recorded because they don't match any student in the roster:

${n}

Please check spelling. Use format: First Last (e.g., \"Alice Adams\")

\n ` : \"\"}\n

\n Details:
\n Cold calls logged: ${result.cold_calls_logged || 0}
\n Absences logged: ${result.absences_logged || 0}
\n ${(result.alerts_sent as string[] || []).length > 0 ? `
Alerts sent: ${(result.alerts_sent as string[]).join(\", \")}` : \"\"}\n

← Submit another report

\n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}\n\nfunction renderError(error: string): Response {\n const html = `\n\n\n Error\n \n \n\n\n

Error

${error}

← Try again

\n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" }, status: 400 });\n}\n\nfunction renderForm(): Response {\n const today = formatDate(new Date());\n\n const html = `\n\n\n Post-Class Report\n \n \n\n\n

📋 Post-Class Report

\n\n Class\n \n\n

Today's On-Call Students

\n\n Date\n \n\n Was class cancelled?\n \n\n

🎯 Students Called On

\n\n Great performance\n \n

Students who did well when called on

\n\n Normal performance\n \n

Students who performed adequately

\n\n Poor performance\n \n

Students who struggled or were unprepared

\n\n

⚠️ Issues

\n\n Refused when called\n \n

Students who declined to answer when called on

\n\n Students absent\n \n

All absent students (whether on call list or not)

\n\n

\n No student data will be recorded for a cancelled class.\n

\n\n \n

\n\n

Need to correct a mistake?

Open the tracking spreadsheet and:

Wrong student counts: Edit the student's row in T&E-Roster or L&C-Roster (these are the source of truth)
Wrong cold call entry: Delete the row from Cold-Call-Log (log)
Duplicate submission: The system auto-skips duplicates, so resubmitting is safe

\n\n \n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"POST\") {\n return handlePost(req);\n }\n return renderForm();\n}\n",[],[287],{"_104":296,"_97":297,"_158":298,"_160":-5,"_161":143,"_162":142,"_164":165,"_106":299,"_101":33,"_168":184,"_170":300,"_172":22,"_173":-5,"_174":301,"_100":302},"43de744e-0c30-11f1-9ca0-42dde27851f2","setup-guide.http.tsx","43de7534-0c30-11f1-9ca0-42dde27851f2",["D",1771353686159],"/**\n * Setup Guide\n * Serves the setup/launch checklist as a rendered HTML page.\n * For Sahar (developer) and Sarah (professor) reference.\n */\n\nexport default function (): Response {\n const html = `\n\n\n Law Student Tracker - Setup Guide\n \n \n\n\n\n

Getting Sarah's Law Student Tracker Running

Step-by-step guide for going from demo mode to live production.
\nSarah is starting mid-semester, so some steps account for importing existing data.

\n\n

What the system does (30-second version)

Every Monday and Wednesday:

Before class — Sarah gets an email listing which students are on-call
After class — Sarah fills out a quick web form: who she called on, how they did, who was absent
Automatically — The system tracks absences, bad performances, and concerning patterns. If a student crosses a threshold (e.g. 3 absences), Sarah gets an alert email

Everything lives in a Google Sheet that Sarah can view anytime. The system writes to it; Sarah reads from it (and can manually correct it).

\n\n

Before you start

You'll need:

Access to Val.town (Sahar's account)
The Google service account credentials file
Sarah's T&E roster (students with first + last names)
Sarah's L&C roster (students with first + last names)
Sarah's L&C syllabus with on-call assignments (which students on which dates)
The Google Form that students use to self-report absences (you need the spreadsheet ID it writes to)

\n\n

Phase 1: Set up the production Google Sheet

\n\n

1.1 Create the spreadsheet

Create a new Google Spreadsheet (or use existing production one)
Share it with the service account email (from credentials JSON, client_email field) — give it Editor access
Copy the spreadsheet ID from the URL (long string between /d/ and /edit)

\n\n

1.2 Create the T&E Roster tab

Name the tab exactly: T&E-Roster
Add these column headers in row 1:

Fill in student_name (e.g. \"Alice Adams\") and last_name (e.g. \"Adams\")
Leave pool empty (system calculates it)
Set all counter columns to 0

Mid-semester note: If Sarah already has data (e.g. \"Alice has 2 absences\"), enter those counts now. The system tracks from here forward.

\n\n

1.3 Create the L&C Roster tab

Name the tab exactly: L&C-Roster
Same columns as T&E (pool not used for L&C — leave blank)
Fill in student names and any existing counts

\n\n

1.4 Create the L&C Schedule tab

Name the tab exactly: L&C-Schedule
Two columns: date and student_name
Enter each remaining class date and assigned students

\n\n \n \n \n \n

date	student_name
2026-02-18	Alice Adams
2026-02-18	Bob Brown
2026-02-20	Carol Clark

Use YYYY-MM-DD format. Multiple students per date = multiple rows.

\n\n

1.5 Other tabs (auto-created)

You don't need to create these — the system creates them on first run:

Cold-Call-Log (log) — audit trail
T&E-On-Call-Next (auto) — today's on-call list
Watch-List (auto) — students at risk
Cancelled-Classes (log) — cancelled class dates
Config (auto) — system configuration

\n\n

Phase 2: Configure Val.town environment variables

Go to Val.town → Settings → Environment Variables:

\n\n \n \n \n \n \n \n \n

Variable	Value	Notes
`GOOGLE_APPLICATION_CREDENTIALS`	Entire JSON content of credentials file	Copy-paste the whole file
`REPORT_API_KEY`	Secret string	Already set; auths the report form
`MAIN_SHEET_ID`	Production spreadsheet ID	From Phase 1
`TE_STUDENT_FORMS_SHEET_ID`	T&E student form spreadsheet ID	Where Google Form writes
`LC_STUDENT_FORMS_SHEET_ID`	L&C student form spreadsheet ID	May be same spreadsheet
`NOTIFICATION_EMAIL`	Any value	Set LAST — enables cron emails

Important: NOTIFICATION_EMAIL doesn't control where emails go (Val.town free tier always emails the account owner). It's an on/off switch. Set = emails on. Unset = emails off.

\n\n

Phase 3: Run the setup endpoints

One-time setup steps. Hit each URL in your browser:

\n\n

3.1 Assign T&E pools

Visit the assign-pools endpoint (add ?dryRun=true first to preview)

This finds the letter that gives the most even 50/50 split and writes mon or wed to each student's pool column.

\n\n

3.2 Add tracking columns (if missing)

Visit the add-roster-columns endpoint (?dryRun=true first, then without)

\n\n

3.3 Verify the connection

Visit the connection test endpoint
Should return JSON showing spreadsheet title, headers, and sample rows
If error: check service account has Editor access to the sheet

\n\n

Phase 4: Configure cron schedules

Set in the Val.town web UI (code doesn't control schedules):

\n\n \n \n \n \n \n \n

Cron file	What it does	Schedule (EST)	UTC Cron
`lc-oncall-notify`	Emails L&C on-call list	8 AM Mon/Wed	`0 13 * * 1,3`
`lc-report-prompt`	Reminds Sarah to report (L&C)	12 PM Mon/Wed	`0 17 * * 1,3`
`oncall-notify`	Emails T&E on-call list	3 PM Mon/Wed	`0 20 * * 1,3`
`te-report-prompt`	Reminds Sarah to report (T&E)	6 PM Mon/Wed	`0 23 * * 1,3`
`weekly-summary`	Friday risk summary	Fri 9 AM	`0 14 * * 5`

To set: Open cron file in Val.town → click schedule icon → enter cron expression. Make sure toggle is ON.

\n\n

Phase 5: Connect the student self-report form

Confirm you have the spreadsheet ID(s) where the form responses go
Make sure the service account has read access to those spreadsheets
Verify the form has these exact questions:

\"Date of class you'll be absent, late-arriving/early-departing, or unprepared\"
\"Will you be absent, unprepared, or late/early?\"
\"Your name\"

If form questions differ: Update constants FORM_COL_DATE, FORM_COL_TYPE, FORM_COL_NAME in utils.tsx, then redeploy with vt push.

\n\n

Phase 6: Test end-to-end

\n\n

6.1 Test on-call selection

Visit T&E selection endpoint — should return 6 students (Mon/Wed only; use ?pool=mon to force)
Visit L&C selection endpoint — should return today's assigned students

\n\n

6.2 Test the report form

Open Sarah's form (link below)
Select a class — on-call list should appear
Submit a test report with a student name
Check Google Sheet — Cold-Call-Log should have a new row, roster counts should update

\n\n

6.3 Test email

Set NOTIFICATION_EMAIL in Val.town env vars
Run a cron manually from Val.town dashboard (or wait for next scheduled run)
Confirm email arrives

\n\n

Phase 7: Hand off to Sarah

\n\n

Sarah's daily workflow

\n\n \n \n \n \n \n \n

When	What happens	What you do
Before class	Email arrives listing on-call students	Note who's on the list
During class	Teach normally	Note performance + absences
After class	Reminder email arrives	Open the form, fill it out (< 2 min)
Friday	Weekly summary email	Review any at-risk students
Anytime	Alert email about a student	Follow the recommended action

\n\n

Filling out the report form

Select the class (T&E or L&C)
On-call students appear at the top for reference
Type student names into the right boxes:\n
- Great — did well when called on
- Normal — adequate
- Poor — struggled or unprepared
- Refused — declined to answer
- Absent — ALL absent students (on-call or not)
\n
Submit. Done.

\n\n

If something goes wrong

Form shows warnings for names it couldn't match — check spelling
\"Need to correct a mistake?\" section at the bottom links to the spreadsheet
Fix wrong counts: Edit the student's row directly in T&E-Roster or L&C-Roster
Remove a bad entry: Delete the row from Cold-Call-Log (log)
Duplicate submissions are safe — system skips them automatically

\n\n

If class is cancelled

Open the form, select the class, mark \"Yes - class was cancelled\", submit. This prevents false alerts.

\n\n

What Sarah should NOT touch

Tabs ending in (auto) — system overwrites these
Tabs ending in (log) — append-only, don't edit unless fixing a mistake
The pool column in T&E-Roster — auto-calculated

\n\n

What Sarah CAN edit freely

Student names in either Roster tab
Counter values (absences, concerning_events, etc.) — these are the source of truth
L&C-Schedule (add/change on-call assignments)
Add or remove students from rosters

\n\n

Troubleshooting

\n\n \n \n \n \n \n \n \n \n \n

Problem	Fix
No emails arriving	Check `NOTIFICATION_EMAIL` is set. Check crons are toggled on with correct schedules.
\"Selection failed\" email	Check Google Sheet is accessible (service account has Editor access)
Wrong students on call	Check pool assignments in T&E-Roster. Run assign-pools to recalculate.
Form shows \"Unauthorized\"	Check `REPORT_API_KEY` in Val.town env vars
Student name not matching	System does fuzzy matching. If still failing, check exact spelling against roster.
Too many emails	Unset `NOTIFICATION_EMAIL` to disable all cron emails instantly.
Student added mid-semester	Add to roster with counters at 0. For T&E, run assign-pools.
Student dropped	Delete row from roster. Cold-Call-Log history stays.

\n\n

Quick reference: All URLs

\n\n \n \n \n \n \n \n \n

What	URL
Sarah's report form	https://sahar--ab2d2176f16511f0a75a42dde27851f2.web.val.run
T&E on-call selection	https://sahar--78f39bfeef4911f0a9a742dde27851f2.web.val.run
L&C on-call selection	https://sahar--2b3b7afaef5611f0bec642dde27851f2.web.val.run
Connection test	https://sahar--c49a6e2cef4711f0998442dde27851f2.web.val.run
Watch list refresh	https://sahar--b1ff5bc6f08f11f0a81342dde27851f2.web.val.run
This setup guide	(you're here)

\n\n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}\n",[],[297],{"_104":304,"_97":305,"_158":306,"_160":-5,"_161":143,"_162":307,"_164":165,"_106":308,"_101":234,"_168":214,"_170":309,"_172":22,"_173":-5,"_174":310,"_100":311},"287652aa-0c2e-11f1-93bf-42dde27851f2","te-report-prompt.cron.tsx","e4b192e0-ef4b-11f0-b248-42dde27851f2",151,["D",1771352781196],"/**\n * T&E Post-Class Report Prompt\n * Runs 6 PM EST Mon/Wed (11 PM UTC)\n * Reminds professor to submit post-class report.\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\nimport { EMAIL_FOOTER, formatDate } from \"./utils.tsx\";\n\nexport default async function() {\n // Val.town free tier: email() always sends to account owner.\n // NOTIFICATION_EMAIL serves as an opt-in flag — if not set, skip silently.\n if (!Deno.env.get(\"NOTIFICATION_EMAIL\")) {\n console.log(\"NOTIFICATION_EMAIL not set — skipping notification.\");\n return;\n }\n\n const today = formatDate(new Date());\n\n await email({\n // Val.town free tier: emails go to account owner\n subject: `[T&E] Trusts & Estates Report - ${today}`,\n text: `Hi Sarah,\n\nTime to submit your post-class report for T&E.\n\nPlease note:\n- Who was absent (not on self-report list)\n- Who you called on and their performance (great/normal/bad)\n- Any students who refused when called\n\nUse the reporting form: https://sahar--ab2d2176f16511f0a75a42dde27851f2.web.val.run\n\nThanks!` + EMAIL_FOOTER,\n });\n\n console.log(`Sent T&E report prompt for ${today}`);\n}\n",[],[305],{"_104":313,"_97":314,"_158":315,"_160":-5,"_161":143,"_162":316,"_164":165,"_106":317,"_101":318,"_168":319,"_170":320,"_172":22,"_173":-5,"_174":321,"_100":322},"289591c4-0c2e-11f1-9217-42dde27851f2","utils.tsx","da859f36-ef65-11f0-8c45-42dde27851f2",156,["D",1771352781351],14,"script","/**\n * Shared utilities for Law Student Tracker\n * Contains name matching, normalization, fuzzy matching, and auth functions.\n */\n\nimport { JWT } from \"npm:google-auth-library\";\n\n// ============================================================================\n// Sheet IDs (two spreadsheets)\n// ============================================================================\n\n/**\n * Main spreadsheet: rosters, cold call log, derived tabs.\n * For production, set MAIN_SHEET_ID env var in Val.town.\n */\nexport const MAIN_SHEET_ID = Deno.env.get(\"MAIN_SHEET_ID\") || \"1Iuoz4e8jYnd787qNMC5x6NMZaWJSuxnWz9zyTyVRRYA\";\n\n/**\n * T&E student self-report form spreadsheet (Google Form writes here).\n * For production, set TE_STUDENT_FORMS_SHEET_ID env var in Val.town.\n */\nexport const TE_STUDENT_FORMS_SHEET_ID = Deno.env.get(\"TE_STUDENT_FORMS_SHEET_ID\") || \"1Iuoz4e8jYnd787qNMC5x6NMZaWJSuxnWz9zyTyVRRYA\";\n\n/**\n * L&C student self-report form spreadsheet (Google Form writes here).\n * For production, set LC_STUDENT_FORMS_SHEET_ID env var in Val.town.\n */\nexport const LC_STUDENT_FORMS_SHEET_ID = Deno.env.get(\"LC_STUDENT_FORMS_SHEET_ID\") || \"1Iuoz4e8jYnd787qNMC5x6NMZaWJSuxnWz9zyTyVRRYA\";\n\n// Legacy alias - will be removed after migration\nexport const STUDENT_FORMS_SHEET_ID = TE_STUDENT_FORMS_SHEET_ID;\n\n// Legacy alias - some code still uses SHEET_ID\nexport const SHEET_ID = MAIN_SHEET_ID;\n\n// ============================================================================\n// Tab Names - Main Spreadsheet\n// ============================================================================\n\n/**\n * Tab names in the MAIN spreadsheet.\n *\n * Three types (suffixes tell Sarah what's safe to edit):\n *\n * SOURCE OF TRUTH (no suffix - Sarah can edit):\n * T&E-Roster, L&C-Roster, L&C-Schedule\n *\n * AUTO-GENERATED (auto) - cleared and rewritten each run:\n * Watch-List (auto), T&E-On-Call-Next (auto), Pending-Review (auto),\n * Config (auto), L&C-On-Call-Next (auto)\n *\n * APPEND-ONLY LOGS (log) - system adds rows, don't edit/delete:\n * Cold-Call-Log (log), T&E-On-Call-History (log), L&C-On-Call-History (log), Cancelled-Classes (log)\n */\nexport const SHEET_TABS = {\n // === SOURCE OF TRUTH (no suffix - Sarah can edit) ===\n TE_ROSTER: \"T&E-Roster\",\n LC_ROSTER: \"L&C-Roster\",\n LC_SCHEDULE: \"L&C-Schedule\", // Pre-assigned on-call dates from syllabus\n\n // === AUTO-GENERATED (auto) - cleared and rewritten each run ===\n TE_ON_CALL: \"T&E-On-Call-Today\", // DEPRECATED: Use TE_ON_CALL_NEXT\n LC_ON_CALL: \"L&C-On-Call-Today\", // DEPRECATED: Use LC_ON_CALL_NEXT\n WATCH_LIST: \"Watch-List (auto)\",\n TE_ON_CALL_NEXT: \"T&E-On-Call-Next (auto)\", // Clean view: only next class (6 students)\n PENDING_REVIEW: \"Pending-Review (auto)\",\n\n // === APPEND-ONLY LOGS (log) - system adds rows, don't edit/delete ===\n COLD_CALL_LOG: \"Cold-Call-Log (log)\",\n TE_ON_CALL_HISTORY: \"T&E-On-Call-History (log)\", // Archive of all past selections\n LC_ON_CALL_HISTORY: \"L&C-On-Call-History (log)\", // Archive of all past selections\n CANCELLED_CLASSES: \"Cancelled-Classes (log)\",\n\n // === LOW-VISIBILITY (auto, kept at end of tab bar) ===\n CONFIG: \"Config (auto)\", // System config (pool_pivot, etc.)\n LC_ON_CALL_NEXT: \"L&C-On-Call-Next (auto)\", // Filtered view of L&C-Schedule\n} as const;\n\n// Warning messages for auto-generated and log tabs\nexport const TAB_WARNINGS = {\n AUTO: \"⚠️ AUTO-GENERATED - Cleared and rewritten each run. Do not edit.\",\n LOG: \"⚠️ APPEND-ONLY LOG - System adds rows. Do not edit or delete.\",\n} as const;\n\n// ============================================================================\n// Tab Names - Student Forms Spreadsheet\n// ============================================================================\n\n/**\n * Tab name in the STUDENT_FORMS spreadsheet.\n * Google Forms creates this automatically.\n */\nexport const STUDENT_FORMS_TAB = \"Form Responses 1\";\n\n// Google Form column headers (exact question text from the student self-report form).\n// If the form questions change, update these strings — they're used in 3 files.\nexport const FORM_COL_DATE = \"Date of class you'll be absent, late-arriving/early-departing, or unprepared\";\nexport const FORM_COL_TYPE = \"Will you be absent, unprepared, or late/early?\";\nexport const FORM_COL_NAME = \"Your name\";\n\n// ============================================================================\n// Email Footer (for Gmail filtering)\n// ============================================================================\n\n/**\n * Unique footer appended to all emails for Gmail auto-forwarding filters.\n * Filter on: \"LawTracker-AutoNotify\" to forward to robot.squad.sm@gmail.com\n */\nexport const EMAIL_FOOTER = \"\\n\\n--\\nLawTracker-AutoNotify\";\n\n// ============================================================================\n// Alert Thresholds (3-tier system)\n// ============================================================================\n\n/**\n * Absence thresholds for escalating alerts.\n * - CONTACT_DEAN (red): Sarah contacts dean + student\n * - WARN_STUDENT (orange): Sarah warns student\n * - MONITOR (yellow): Early warning, watch list only\n */\nexport const ABSENCE_CONTACT_DEAN = 4;\nexport const ABSENCE_WARN_STUDENT = 3;\nexport const ABSENCE_MONITOR = 2;\n\n/**\n * Concerning event thresholds (absences + unprepared + refused + bad performance).\n */\nexport const CONCERNING_CONTACT_DEAN = 5;\nexport const CONCERNING_WARN_STUDENT = 4;\nexport const CONCERNING_MONITOR = 3;\n\n// ============================================================================\n// Shared Types\n// ============================================================================\n\n/**\n * A single cold call result from a post-class report.\n */\nexport interface ColdCallEntry {\n student_name: string;\n result: \"completed\" | \"absent\" | \"refused\";\n performance?: \"great\" | \"normal\" | \"bad\";\n}\n\n/**\n * Payload for POST /post-class-report endpoint.\n */\nexport interface ReportPayload {\n date: string;\n class_type: \"te\" | \"lc\";\n cold_calls: ColdCallEntry[];\n absences: string[]; // Names of students who were absent (not on on-call list)\n cancelled?: boolean; // True if class was cancelled\n}\n\n/**\n * Determines if a cold call result is a \"concerning event\" for threshold tracking.\n * Concerning events: absent (announced or not), refused, unprepared, or bad performance.\n */\nexport function isConcerningEvent(\n result: ColdCallEntry[\"result\"] | \"unprepared\" | \"absent-announced\",\n performance?: ColdCallEntry[\"performance\"] | \"self-reported\",\n): boolean {\n // Any type of absence is concerning\n if (result === \"absent\" || result === \"absent-announced\") return true;\n // Other concerning events\n if (result === \"refused\" || result === \"unprepared\") return true;\n // Bad performance on completed cold call\n if (performance === \"bad\") return true;\n return false;\n}\n\n/**\n * Formats a Date object as YYYY-MM-DD string for comparison and storage.\n */\nexport function formatDate(date: Date): string {\n return date.toISOString().split(\"T\")[0];\n}\n\n// ============================================================================\n// Authentication\n// ============================================================================\n\n/**\n * Creates authenticated JWT client for Google Sheets API.\n * Requires GOOGLE_APPLICATION_CREDENTIALS env var containing JSON credentials.\n */\nexport function getAuthClient(): JWT {\n const credsJson = Deno.env.get(\"GOOGLE_APPLICATION_CREDENTIALS\");\n if (!credsJson) {\n throw new Error(\n \"GOOGLE_APPLICATION_CREDENTIALS env var not set. Configure in Val.town settings.\",\n );\n }\n const creds = JSON.parse(credsJson);\n return new JWT({\n email: creds.client_email,\n key: creds.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"],\n });\n}\n\n// ============================================================================\n// Name Matching\n// ============================================================================\n\n/**\n * Normalize a name for comparison:\n * - Lowercase\n * - Collapse multiple whitespace to single space\n * - Trim leading/trailing whitespace\n * - Handle \"Last, First\" -> \"First Last\" conversion\n */\nexport function normalizeName(name: string): string {\n if (!name || typeof name !== \"string\") return \"\";\n\n let normalized = name.toLowerCase().trim().replace(/\\s+/g, \" \");\n\n // Handle \"Last, First\" format -> \"First Last\"\n if (normalized.includes(\",\")) {\n const [last, first] = normalized.split(\",\").map((s) => s.trim());\n if (first && last) {\n normalized = `${first} ${last}`;\n }\n }\n\n return normalized;\n}\n\n/**\n * Calculate Levenshtein distance between two strings.\n * Used for fuzzy matching names with typos.\n */\nexport function levenshteinDistance(a: string, b: string): number {\n if (a.length === 0) return b.length;\n if (b.length === 0) return a.length;\n\n const matrix: number[][] = [];\n\n // Initialize first column\n for (let i = 0; i <= b.length; i++) {\n matrix[i] = [i];\n }\n\n // Initialize first row\n for (let j = 0; j <= a.length; j++) {\n matrix[0][j] = j;\n }\n\n // Fill in the rest\n for (let i = 1; i <= b.length; i++) {\n for (let j = 1; j <= a.length; j++) {\n if (b.charAt(i - 1) === a.charAt(j - 1)) {\n matrix[i][j] = matrix[i - 1][j - 1];\n } else {\n matrix[i][j] = Math.min(\n matrix[i - 1][j - 1] + 1, // substitution\n matrix[i][j - 1] + 1, // insertion\n matrix[i - 1][j] + 1, // deletion\n );\n }\n }\n }\n\n return matrix[b.length][a.length];\n}\n\n/**\n * Match result from findMatchingName\n */\nexport interface NameMatchResult {\n matched: true;\n rosterName: string;\n inputName: string;\n matchType: \"exact\" | \"normalized\" | \"fuzzy\";\n distance?: number; // Only for fuzzy matches\n}\n\nexport interface NameNoMatchResult {\n matched: false;\n inputName: string;\n closestCandidate?: string;\n closestDistance?: number;\n}\n\nexport type NameMatch = NameMatchResult | NameNoMatchResult;\n\n/**\n * Find matching name from roster given an input name.\n * Attempts matching in order:\n * 1. Exact match (case-sensitive)\n * 2. Normalized match (case-insensitive, whitespace normalized, Last/First flip)\n * 3. Fuzzy match (Levenshtein distance <= 2)\n *\n * @param inputName - The name from the form\n * @param rosterNames - Array of canonical names from the roster\n * @param maxDistance - Maximum Levenshtein distance for fuzzy match (default 2)\n * @returns NameMatch indicating success/failure and details\n */\nexport function findMatchingName(\n inputName: string,\n rosterNames: string[],\n maxDistance = 2,\n): NameMatch {\n if (!inputName || !rosterNames.length) {\n return { matched: false, inputName: inputName || \"\" };\n }\n\n // 1. Exact match\n if (rosterNames.includes(inputName)) {\n return {\n matched: true,\n rosterName: inputName,\n inputName,\n matchType: \"exact\",\n };\n }\n\n // 2. Normalized match\n const normalizedInput = normalizeName(inputName);\n const normalizedRoster = rosterNames.map((n) => ({\n original: n,\n normalized: normalizeName(n),\n }));\n\n for (const { original, normalized } of normalizedRoster) {\n if (normalized === normalizedInput) {\n return {\n matched: true,\n rosterName: original,\n inputName,\n matchType: \"normalized\",\n };\n }\n }\n\n // 3. Fuzzy match - find best match within threshold\n let bestMatch: { name: string; distance: number } | null = null;\n\n for (const { original, normalized } of normalizedRoster) {\n const distance = levenshteinDistance(normalizedInput, normalized);\n if (distance <= maxDistance) {\n if (!bestMatch || distance < bestMatch.distance) {\n bestMatch = { name: original, distance };\n }\n }\n }\n\n if (bestMatch) {\n return {\n matched: true,\n rosterName: bestMatch.name,\n inputName,\n matchType: \"fuzzy\",\n distance: bestMatch.distance,\n };\n }\n\n // No match found - return closest candidate for debugging\n let closest: { name: string; distance: number } | null = null;\n for (const { original, normalized } of normalizedRoster) {\n const distance = levenshteinDistance(normalizedInput, normalized);\n if (!closest || distance < closest.distance) {\n closest = { name: original, distance };\n }\n }\n\n return {\n matched: false,\n inputName,\n closestCandidate: closest?.name,\n closestDistance: closest?.distance,\n };\n}\n\n/**\n * Parse comma-separated list of names.\n * Handles leading/trailing whitespace around each name.\n * Filters out empty strings.\n */\nexport function parseNameList(input: string): string[] {\n if (!input || typeof input !== \"string\") return [];\n\n return input\n .split(/[,\\n]/) // Split on comma OR newline\n .map((s) => s.trim())\n .filter((s) => s.length > 0);\n}\n\n/**\n * Map class string from form to canonical class_type.\n * Form might say \"T&E\", \"Trusts & Estates\", \"te\", etc.\n */\nexport function parseClassType(classStr: string): \"te\" | \"lc\" | null {\n if (!classStr) return null;\n\n const lower = classStr.toLowerCase().trim();\n\n if (\n lower === \"te\" ||\n lower === \"t&e\" ||\n lower.includes(\"trusts\") ||\n lower.includes(\"estates\")\n ) {\n return \"te\";\n }\n\n if (\n lower === \"lc\" ||\n lower === \"l&c\" ||\n lower.includes(\"capitalism\") ||\n lower.includes(\"law &\")\n ) {\n return \"lc\";\n }\n\n return null;\n}\n\n/**\n * Parse date string from Google Sheets into YYYY-MM-DD format.\n * Handles common formats: \"MM/DD/YYYY\", \"M/D/YYYY\", \"YYYY-MM-DD\"\n * Returns null if unparseable.\n */\nexport function parseSheetDate(dateStr: string): string | null {\n if (!dateStr || typeof dateStr !== \"string\") return null;\n\n const trimmed = dateStr.trim();\n\n // Already ISO format: \"2026-01-12\"\n if (/^\\d{4}-\\d{2}-\\d{2}$/.test(trimmed)) {\n return trimmed;\n }\n\n // US format: \"1/12/2026\" or \"01/12/2026\"\n const usMatch = trimmed.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n if (usMatch) {\n const [, month, day, year] = usMatch;\n return `${year}-${month.padStart(2, \"0\")}-${day.padStart(2, \"0\")}`;\n }\n\n // Fallback: try native parsing\n const fallback = new Date(trimmed);\n if (!isNaN(fallback.getTime())) {\n return fallback.toISOString().split(\"T\")[0];\n }\n\n return null;\n}\n\n// ============================================================================\n// Watch List Tab Management\n// ============================================================================\n\n/**\n * Risk level for students approaching thresholds.\n */\nexport type RiskLevel = \"IMMINENT\" | \"WATCH\" | \"CAUTION\";\n\n/**\n * Student data for Watch List display.\n */\nexport interface WatchListStudent {\n name: string;\n class: \"T&E\" | \"L&C\";\n absences: number;\n concerning: number;\n riskLevel: RiskLevel;\n lastCalled: string;\n}\n\n/**\n * Calculate risk level based on counts.\n * Risk levels map to email tiers:\n * - IMMINENT = [ALERT] email (dean notification at 4+ absences, 5+ concerning)\n * - WATCH = [WARNING] email (warn student at 3 absences, 4 concerning)\n * - CAUTION = [WATCH] email (early warning at 2 absences, 3 concerning)\n */\nexport function calculateRiskLevel(absences: number, concerning: number): RiskLevel {\n // At or above dean threshold (4 absences, 5 concerning)\n if (absences >= 4 || concerning >= 5) return \"IMMINENT\";\n // At warning level - Sarah warns student (3 absences, 4 concerning)\n if (absences === 3 || concerning === 4) return \"WATCH\";\n // At early warning level (2 absences, 3 concerning)\n if (absences === 2 || concerning === 3) return \"CAUTION\";\n return \"CAUTION\";\n}\n\n/**\n * Sort priority for risk levels (lower = higher priority).\n */\nfunction riskPriority(level: RiskLevel): number {\n switch (level) {\n case \"IMMINENT\": return 0;\n case \"WATCH\": return 1;\n case \"CAUTION\": return 2;\n }\n}\n\n/**\n * Updates the Watch List tab with current at-risk students.\n * Clears and rewrites all rows each time (idempotent).\n *\n * @param doc - Loaded GoogleSpreadsheet instance\n * @returns Summary of what was written\n */\nexport async function updateWatchListTab(doc: {\n sheetsByTitle: Record;\n addSheet: (opts: { title: string; headerValues: string[] }) => Promise;\n}): Promise<{ studentsAtRisk: number; imminent: number; watch: number }> {\n // Get or create Watch List tab\n let watchSheet = doc.sheetsByTitle[SHEET_TABS.WATCH_LIST] as {\n clear: () => Promise;\n setHeaderRow: (headers: string[]) => Promise;\n addRows: (rows: Record[]) => Promise;\n loadHeaderRow: () => Promise;\n } | undefined;\n\n if (!watchSheet) {\n watchSheet = await doc.addSheet({\n title: SHEET_TABS.WATCH_LIST,\n headerValues: [\"Name\", \"Class\", \"Absences\", \"Concerning\", \"Risk Level\", \"Last Called\"],\n }) as typeof watchSheet;\n }\n\n // Clear existing data (keep headers)\n await watchSheet!.loadHeaderRow();\n await watchSheet!.clear();\n await watchSheet!.setHeaderRow([\"Name\", \"Class\", \"Absences\", \"Concerning\", \"Risk Level\", \"Last Called\"]);\n\n // Collect at-risk students from both rosters\n const atRisk: WatchListStudent[] = [];\n\n // Process T&E Roster\n const teSheet = doc.sheetsByTitle[SHEET_TABS.TE_ROSTER] as {\n loadHeaderRow: () => Promise;\n getRows: () => Promise string }>>;\n } | undefined;\n if (teSheet) {\n await teSheet.loadHeaderRow();\n const teRows = await teSheet.getRows();\n for (const row of teRows) {\n const absences = parseInt(row.get(\"absences\") || \"0\", 10);\n const concerning = parseInt(row.get(\"concerning_events\") || \"0\", 10);\n if (absences >= 2 || concerning >= 3) {\n atRisk.push({\n name: row.get(\"student_name\") || \"\",\n class: \"T&E\",\n absences,\n concerning,\n riskLevel: calculateRiskLevel(absences, concerning),\n lastCalled: row.get(\"last_called\") || \"\",\n });\n }\n }\n }\n\n // Process L&C Roster\n const lcSheet = doc.sheetsByTitle[SHEET_TABS.LC_ROSTER] as typeof teSheet;\n if (lcSheet) {\n await lcSheet.loadHeaderRow();\n const lcRows = await lcSheet.getRows();\n for (const row of lcRows) {\n const absences = parseInt(row.get(\"absences\") || \"0\", 10);\n const concerning = parseInt(row.get(\"concerning_events\") || \"0\", 10);\n if (absences >= 2 || concerning >= 3) {\n atRisk.push({\n name: row.get(\"student_name\") || \"\",\n class: \"L&C\",\n absences,\n concerning,\n riskLevel: calculateRiskLevel(absences, concerning),\n lastCalled: row.get(\"last_called\") || \"\",\n });\n }\n }\n }\n\n // Sort by risk level, then concerning (desc), then absences (desc)\n atRisk.sort((a, b) => {\n const riskDiff = riskPriority(a.riskLevel) - riskPriority(b.riskLevel);\n if (riskDiff !== 0) return riskDiff;\n const concerningDiff = b.concerning - a.concerning;\n if (concerningDiff !== 0) return concerningDiff;\n return b.absences - a.absences;\n });\n\n // Write rows\n if (atRisk.length > 0) {\n await watchSheet!.addRows(\n atRisk.map((s) => ({\n Name: s.name,\n Class: s.class,\n Absences: s.absences,\n Concerning: s.concerning,\n \"Risk Level\": s.riskLevel,\n \"Last Called\": s.lastCalled,\n }))\n );\n }\n\n return {\n studentsAtRisk: atRisk.length,\n imminent: atRisk.filter((s) => s.riskLevel === \"IMMINENT\").length,\n watch: atRisk.filter((s) => s.riskLevel === \"WATCH\").length,\n };\n}\n\n// ============================================================================\n// Config Tab Helpers\n// ============================================================================\n\n/**\n * Read a value from the Config tab.\n * Returns null if Config tab doesn't exist or key not found.\n */\nexport async function getConfigValue(\n doc: { sheetsByTitle: Record },\n key: string,\n): Promise {\n const configSheet = doc.sheetsByTitle[SHEET_TABS.CONFIG] as {\n loadHeaderRow: () => Promise;\n getRows: () => Promise string }>>;\n } | undefined;\n\n if (!configSheet) return null;\n\n await configSheet.loadHeaderRow();\n const rows = await configSheet.getRows();\n const row = rows.find((r) => r.get(\"key\") === key);\n return row?.get(\"value\") || null;\n}\n",[],[314],{"_104":324,"_97":325,"_158":326,"_160":-5,"_161":143,"_162":327,"_164":165,"_106":328,"_101":203,"_168":214,"_170":329,"_172":22,"_173":-5,"_174":330,"_100":331},"4c90607a-f7a4-11f0-aa79-42dde27851f2","weekly-summary.cron.tsx","b1f82aae-f08f-11f0-952c-42dde27851f2",137,["D",1769094547928],"/**\n * Weekly Summary Email\n * Runs Friday 9 AM EST (14:00 UTC)\n * Sends summary of students above alert thresholds and their recent activity.\n */\n\nimport { GoogleSpreadsheet } from \"npm:google-spreadsheet\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport {\n ABSENCE_CONTACT_DEAN,\n ABSENCE_MONITOR,\n ABSENCE_WARN_STUDENT,\n CONCERNING_CONTACT_DEAN,\n CONCERNING_MONITOR,\n CONCERNING_WARN_STUDENT,\n EMAIL_FOOTER,\n formatDate,\n getAuthClient,\n isConcerningEvent,\n SHEET_ID,\n SHEET_TABS,\n} from \"./utils.tsx\";\n\ntype RiskLevel = \"CONTACT_DEAN\" | \"WARN_STUDENT\" | \"MONITOR\";\n\n/**\n * Determine risk level based on absences and concerning events.\n * Returns null if student is below all thresholds.\n */\nfunction getRiskLevel(absences: number, concerning: number): RiskLevel | null {\n if (absences >= ABSENCE_CONTACT_DEAN || concerning >= CONCERNING_CONTACT_DEAN) return \"CONTACT_DEAN\";\n if (absences >= ABSENCE_WARN_STUDENT || concerning >= CONCERNING_WARN_STUDENT) return \"WARN_STUDENT\";\n if (absences >= ABSENCE_MONITOR || concerning >= CONCERNING_MONITOR) return \"MONITOR\";\n return null;\n}\n\ninterface StudentAtRisk {\n name: string;\n classType: \"T&E\" | \"L&C\";\n absences: number;\n concerningEvents: number;\n recentActivity: string[];\n riskLevel: RiskLevel;\n}\n\ninterface IntegrityMismatch {\n student: string;\n classType: string;\n field: \"absences\" | \"concerning\" | \"cold_calls\";\n rosterCount: number;\n logCount: number;\n}\n\n/**\n * Check data integrity between roster counts and Cold Call Log entries.\n */\nfunction checkDataIntegrity(\n logRows: Array<{ get: (key: string) => string }>,\n rosterRows: Array<{ get: (key: string) => string }>,\n classType: string,\n): IntegrityMismatch[] {\n const mismatches: IntegrityMismatch[] = [];\n\n // Build counts from log\n const logCounts = new Map();\n\n for (const row of logRows) {\n const name = row.get(\"student_name\");\n const result = row.get(\"result\") || \"\";\n const performance = row.get(\"performance\") || \"\";\n\n if (!name) continue;\n\n if (!logCounts.has(name)) {\n logCounts.set(name, { absences: 0, concerning: 0, coldCalls: 0 });\n }\n const counts = logCounts.get(name)!;\n\n // Count cold calls (completed or refused)\n if (result === \"completed\" || result === \"refused\") {\n counts.coldCalls++;\n }\n\n // Count absences (both announced and unannounced)\n if (result === \"absent\" || result === \"absent-announced\") {\n counts.absences++;\n }\n\n // Count concerning events (uses shared logic from utils.tsx)\n if (isConcerningEvent(result as any, performance as any)) {\n counts.concerning++;\n }\n }\n\n // Compare with roster\n for (const row of rosterRows) {\n const name = row.get(\"student_name\");\n if (!name) continue;\n\n const rosterAbsences = parseInt(row.get(\"absences\") || \"0\", 10);\n const rosterConcerning = parseInt(row.get(\"concerning_events\") || \"0\", 10);\n\n const logData = logCounts.get(name) || { absences: 0, concerning: 0, coldCalls: 0 };\n\n if (rosterAbsences !== logData.absences) {\n mismatches.push({\n student: name,\n classType,\n field: \"absences\",\n rosterCount: rosterAbsences,\n logCount: logData.absences,\n });\n }\n\n if (rosterConcerning !== logData.concerning) {\n mismatches.push({\n student: name,\n classType,\n field: \"concerning\",\n rosterCount: rosterConcerning,\n logCount: logData.concerning,\n });\n }\n\n const rosterColdCalls = parseInt(row.get(\"cold_call_count\") || \"0\", 10);\n if (rosterColdCalls !== logData.coldCalls) {\n mismatches.push({\n student: name,\n classType,\n field: \"cold_calls\",\n rosterCount: rosterColdCalls,\n logCount: logData.coldCalls,\n });\n }\n }\n\n return mismatches;\n}\n\n/**\n * Get recent activity from Cold Call Log for a student.\n * Returns entries from the last 2 weeks.\n */\nfunction getRecentActivity(\n logRows: Array<{ get: (key: string) => string }>,\n studentName: string,\n cutoffDate: Date,\n): string[] {\n const activity: string[] = [];\n\n for (const row of logRows) {\n if (row.get(\"student_name\") !== studentName) continue;\n\n const dateStr = row.get(\"date\");\n if (!dateStr) continue;\n\n const rowDate = new Date(dateStr);\n if (rowDate < cutoffDate) continue;\n\n const result = row.get(\"result\");\n const performance = row.get(\"performance\");\n\n let entry = `${dateStr}: ${result}`;\n if (performance && performance !== \"normal\" && performance !== \"not-on-call\") {\n entry += ` (${performance})`;\n }\n activity.push(entry);\n }\n\n return activity;\n}\n\nexport default async function () {\n const auth = getAuthClient();\n const doc = new GoogleSpreadsheet(SHEET_ID, auth);\n await doc.loadInfo();\n\n const studentsAtRisk: StudentAtRisk[] = [];\n\n // Two weeks ago\n const cutoffDate = new Date();\n cutoffDate.setDate(cutoffDate.getDate() - 14);\n\n // Load Cold Call Log once for activity lookup\n const logSheet = doc.sheetsByTitle[SHEET_TABS.COLD_CALL_LOG];\n let logRows: Array<{ get: (key: string) => string }> = [];\n if (logSheet) {\n await logSheet.loadHeaderRow();\n logRows = await logSheet.getRows();\n }\n\n // Check T&E Roster\n const teSheet = doc.sheetsByTitle[SHEET_TABS.TE_ROSTER];\n let teRows: Array<{ get: (key: string) => string }> = [];\n if (teSheet) {\n await teSheet.loadHeaderRow();\n teRows = await teSheet.getRows();\n\n for (const row of teRows) {\n const name = row.get(\"student_name\");\n if (!name) continue;\n\n const absences = parseInt(row.get(\"absences\") || \"0\", 10);\n const concerning = parseInt(row.get(\"concerning_events\") || \"0\", 10);\n\n const riskLevel = getRiskLevel(absences, concerning);\n if (riskLevel) {\n studentsAtRisk.push({\n name,\n classType: \"T&E\",\n absences,\n concerningEvents: concerning,\n recentActivity: getRecentActivity(logRows, name, cutoffDate),\n riskLevel,\n });\n }\n }\n }\n\n // Check L&C Roster\n const lcSheet = doc.sheetsByTitle[SHEET_TABS.LC_ROSTER];\n let lcRows: Array<{ get: (key: string) => string }> = [];\n if (lcSheet) {\n await lcSheet.loadHeaderRow();\n lcRows = await lcSheet.getRows();\n\n for (const row of lcRows) {\n const name = row.get(\"student_name\");\n if (!name) continue;\n\n const absences = parseInt(row.get(\"absences\") || \"0\", 10);\n const concerning = parseInt(row.get(\"concerning_events\") || \"0\", 10);\n\n const riskLevel = getRiskLevel(absences, concerning);\n if (riskLevel) {\n studentsAtRisk.push({\n name,\n classType: \"L&C\",\n absences,\n concerningEvents: concerning,\n recentActivity: getRecentActivity(logRows, name, cutoffDate),\n riskLevel,\n });\n }\n }\n }\n\n // Run data integrity check\n const integrityMismatches: IntegrityMismatch[] = [\n ...checkDataIntegrity(logRows, teRows, \"T&E\"),\n ...checkDataIntegrity(logRows, lcRows, \"L&C\"),\n ];\n\n // Build email\n let subject: string;\n let bodyText: string;\n\n // Helper to format a student summary\n const formatStudent = (s: StudentAtRisk): string => {\n const reasons: string[] = [];\n if (s.absences > 0) reasons.push(`${s.absences} absence${s.absences > 1 ? \"s\" : \"\"}`);\n if (s.concerningEvents > s.absences) reasons.push(`${s.concerningEvents} concerning`);\n return ` - ${s.name} (${s.classType}): ${reasons.join(\", \")}`;\n };\n\n if (studentsAtRisk.length === 0) {\n subject = \"[LawTracker] Weekly Summary - All Clear\";\n bodyText = `Weekly Summary for ${formatDate(new Date())}\n\nAll students are currently below monitoring thresholds.\n\nThresholds:\n- Monitor: ${ABSENCE_MONITOR}+ absences OR ${CONCERNING_MONITOR}+ concerning\n- Warn: ${ABSENCE_WARN_STUDENT}+ absences OR ${CONCERNING_WARN_STUDENT}+ concerning\n- Dean: ${ABSENCE_CONTACT_DEAN}+ absences OR ${CONCERNING_CONTACT_DEAN}+ concerning`;\n } else {\n // Group by risk level\n const contactDean = studentsAtRisk.filter(s => s.riskLevel === \"CONTACT_DEAN\");\n const warnStudent = studentsAtRisk.filter(s => s.riskLevel === \"WARN_STUDENT\");\n const monitor = studentsAtRisk.filter(s => s.riskLevel === \"MONITOR\");\n\n // Build subject based on highest severity\n if (contactDean.length > 0) {\n subject = `[LawTracker] URGENT - ${contactDean.length} student(s) need dean notification`;\n } else if (warnStudent.length > 0) {\n subject = `[LawTracker] Weekly Summary - ${warnStudent.length} student(s) need warning`;\n } else {\n subject = `[LawTracker] Weekly Summary - ${monitor.length} student(s) to monitor`;\n }\n\n // Build sections\n const sections: string[] = [];\n\n if (contactDean.length > 0) {\n sections.push(`CONTACT DEAN (${contactDean.length}):\\n${contactDean.map(formatStudent).join(\"\\n\")}`);\n }\n if (warnStudent.length > 0) {\n sections.push(`WARN STUDENT (${warnStudent.length}):\\n${warnStudent.map(formatStudent).join(\"\\n\")}`);\n }\n if (monitor.length > 0) {\n sections.push(`MONITOR (${monitor.length}):\\n${monitor.map(formatStudent).join(\"\\n\")}`);\n }\n\n bodyText = `Weekly Summary for ${formatDate(new Date())}\n\n${studentsAtRisk.length} student(s) need attention:\n\n${sections.join(\"\\n\\n\")}\n\n---\nThresholds: Monitor (${ABSENCE_MONITOR}/${CONCERNING_MONITOR}), Warn (${ABSENCE_WARN_STUDENT}/${CONCERNING_WARN_STUDENT}), Dean (${ABSENCE_CONTACT_DEAN}/${CONCERNING_CONTACT_DEAN})`;\n }\n\n // Append data integrity issues if any\n if (integrityMismatches.length > 0) {\n bodyText += `\\n\\n⚠️ DATA INTEGRITY ISSUES DETECTED:\\n\\nThe following counts don't match between roster and Cold Call Log:\\n`;\n for (const m of integrityMismatches) {\n bodyText += `\\n- ${m.student} (${m.classType}): ${m.field} - roster=${m.rosterCount}, log=${m.logCount}`;\n }\n bodyText += `\\n\\nPlease review and reconcile manually, or contact Sahar.`;\n }\n\n await email({\n subject,\n text: bodyText + EMAIL_FOOTER,\n });\n\n console.log(`Sent weekly summary: ${studentsAtRisk.length} students at risk, ${integrityMismatches.length} integrity issues`);\n}\n",[],[325],"files",[155,177,188,197,207,218,228,238,247,256,266,276,285,295,303,312,323],"counts",{"_336":33,"_337":183,"_338":33,"_339":340,"_343":344},"pulls","branches","forks","envVars",{"_341":213,"_342":33},"count","emptyCount","connections",{"_341":33,"_345":33},"unfilledCount","contents",[348,351,354,357,360,363,366,369,372,375,378,381,384,387,390,393,396],{"_104":156,"_97":157,"_158":159,"_160":-5,"_161":143,"_162":163,"_164":165,"_106":349,"_101":167,"_168":169,"_170":171,"_172":22,"_173":-5,"_100":350},["D",1768408310405],[157],{"_104":178,"_97":179,"_158":180,"_160":-5,"_161":143,"_162":181,"_164":165,"_106":352,"_101":183,"_168":184,"_170":185,"_172":22,"_173":-5,"_100":353},["D",1768327845603],[179],{"_104":189,"_97":190,"_158":191,"_160":-5,"_161":143,"_162":192,"_164":165,"_106":355,"_101":183,"_168":184,"_170":194,"_172":22,"_173":-5,"_100":356},["D",1769094548113],[190],{"_104":198,"_97":199,"_158":200,"_160":-5,"_161":143,"_162":201,"_164":165,"_106":358,"_101":203,"_168":184,"_170":204,"_172":22,"_173":-5,"_100":359},["D",1771352781121],[199],{"_104":208,"_97":209,"_158":210,"_160":-5,"_161":143,"_162":211,"_164":165,"_106":361,"_101":213,"_168":214,"_170":215,"_172":22,"_173":-5,"_100":362},["D",1771352781152],[209],{"_104":219,"_97":220,"_158":221,"_160":-5,"_161":143,"_162":222,"_164":165,"_106":364,"_101":224,"_168":184,"_170":225,"_172":22,"_173":-5,"_100":365},["D",1771352781086],[220],{"_104":229,"_97":230,"_158":231,"_160":-5,"_161":143,"_162":232,"_164":165,"_106":367,"_101":234,"_168":214,"_170":235,"_172":22,"_173":-5,"_100":368},["D",1771352781303],[230],{"_104":239,"_97":240,"_158":241,"_160":-5,"_161":143,"_162":242,"_164":165,"_106":370,"_101":167,"_168":184,"_170":244,"_172":22,"_173":-5,"_100":371},["D",1768257137698],[240],{"_104":248,"_97":249,"_158":250,"_160":-5,"_161":143,"_162":251,"_164":165,"_106":373,"_101":234,"_168":214,"_170":253,"_172":22,"_173":-5,"_100":374},["D",1771352781251],[249],{"_104":257,"_97":258,"_158":259,"_160":-5,"_161":143,"_162":260,"_164":165,"_106":376,"_101":262,"_168":184,"_170":263,"_172":22,"_173":-5,"_100":377},["D",1771352781129],[258],{"_104":267,"_97":268,"_158":269,"_160":-5,"_161":143,"_162":270,"_164":165,"_106":379,"_101":272,"_168":184,"_170":273,"_172":22,"_173":-5,"_100":380},["D",1771352781114],[268],{"_104":277,"_97":278,"_158":279,"_160":-5,"_161":143,"_162":280,"_164":165,"_106":382,"_101":33,"_168":184,"_170":282,"_172":22,"_173":-5,"_100":383},["D",1768316040524],[278],{"_104":286,"_97":287,"_158":288,"_160":-5,"_161":143,"_162":289,"_164":165,"_106":385,"_101":291,"_168":184,"_170":292,"_172":22,"_173":-5,"_100":386},["D",1771352781270],[287],{"_104":296,"_97":297,"_158":298,"_160":-5,"_161":143,"_162":142,"_164":165,"_106":388,"_101":33,"_168":184,"_170":300,"_172":22,"_173":-5,"_100":389},["D",1771353686159],[297],{"_104":304,"_97":305,"_158":306,"_160":-5,"_161":143,"_162":307,"_164":165,"_106":391,"_101":234,"_168":214,"_170":309,"_172":22,"_173":-5,"_100":392},["D",1771352781196],[305],{"_104":313,"_97":314,"_158":315,"_160":-5,"_161":143,"_162":316,"_164":165,"_106":394,"_101":318,"_168":319,"_170":320,"_172":22,"_173":-5,"_100":395},["D",1771352781351],[314],{"_104":324,"_97":325,"_158":326,"_160":-5,"_161":143,"_162":327,"_164":165,"_106":397,"_101":203,"_168":214,"_170":329,"_172":22,"_173":-5,"_100":398},["D",1769094547928],[325],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_95":96,"_97":98,"_102":407,"_339":412,"_438":22},{"_104":105,"_97":98,"_106":408,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":-5,"_119":33,"_16":120,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":409,"_135":410,"_140":411,"_152":22},["D",1754054718011],{"_95":96,"_133":134},{"_95":96,"_137":134,"_14":114,"_138":139},{"_101":142,"_97":45,"_104":143,"_144":105,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":98,"_151":96},[413,419,422,426,430,434],{"_414":415,"_106":416,"_417":-5,"_112":74,"_418":22},"key","LC_STUDENT_FORMS_SHEET_ID",["D",1769443101599],"updatedAt","isEmpty",{"_414":420,"_106":421,"_417":-5,"_112":74,"_418":22},"TE_STUDENT_FORMS_SHEET_ID",["D",1769443092272],{"_414":423,"_106":424,"_417":425,"_112":74,"_418":22},"MAIN_SHEET_ID",["D",1769443069988],["D",1769443082479],{"_414":427,"_106":428,"_417":-5,"_112":429,"_418":22},"NOTIFICATION_EMAIL",["D",1768254263750],"sayhar+test@gmail.com",{"_414":431,"_106":432,"_417":-5,"_112":433,"_418":22},"REPORT_API_KEY",["D",1768237644993],"internal to this project",{"_414":435,"_106":436,"_417":-5,"_112":437,"_418":22},"GOOGLE_APPLICATION_CREDENTIALS",["D",1768173047083],"sheets bot","isTeamOrg","actionData","errors"]

Key	Description
LC_STUDENT_FORMS_SHEET_ID
TE_STUDENT_FORMS_SHEET_ID
MAIN_SHEET_ID
NOTIFICATION_EMAIL	sayhar+test@gmail.com
REPORT_API_KEY	internal to this project
GOOGLE_APPLICATION_CREDENTIALS	sheets bot

sahar

law-student-tracker

Environment variables