Site Status & Change Log
A full record of what's been built, what's pending, and what SQL needs to be run in Supabase.
28
Pages Built
6
Supabase Tables
3
Pending SQL Steps
2
Sites (FE + WBL)
Student Portal
✓
Google OAuth Login (login.html)
Students sign in with BPS101 Google accounts. Automatically routes teachers to teacher-hub.html and students to dashboard.html. Checks teachers table for role.
May 29
✓
Student Dashboard (dashboard.html)
Hours progress bar (of 60), bootcamp phase tracker, weekly checklist (projected schedule / actual hours / reflection), portfolio section, quick action cards.
May 29
✓
Weekly Hours Log (weekly-log.html)
Two-phase form: projected schedule (Sunday before) and actual hours (Sunday after). Day-by-day grid Mon–Sun with location, supervisor, expected time, actual hours. Auto-calculates totals. Saves to weekly_logs table.
May 29
✓
Weekly Reflection (weekly-reflection.html)
9-question form matching the original Google Form. Includes employability skill selector (all 10 skills). Saves to weekly_reflections table. Shows "already submitted" state if done this week.
May 29
✓
Bootcamp (bootcamp.html)
4-phase structure (Professional Identity → Interview Prep → Workplace Readiness → Launch). Each phase has expandable activity cards with in-class descriptions, deliverable submissions, and Supabase task tracking. Phase 4 generates a Launch Card.
Jun 3
Teacher Hub
✓
Teacher Hub (teacher-hub.html)
Google OAuth protected (checks teachers table). Links to: Student Progress, Placement Directory, Email Templates, Observation Rubric, Job Descriptions, Student Submissions, Site Status, Pacing Guide, Standards.
May 29–Jun 3
✓
Student Submissions Viewer (teacher-submissions.html)
View all weekly hours logs and reflections. Tabs for each type. Search by student name, filter by week. Click any row to expand full details including day-by-day hours grid or all 9 reflection answers. Stats strip at top.
May 29
✓
Site Status (this page)
Full changelog and status of all features. Pending SQL steps. Known issues. Update manually when new features are added.
Jun 3
✓
Pacing Guide (teacher-pacing.html)
Bootcamp pacing for daily vs. every-other-day sections. Phase milestones, flexibility notes, interview window guidance.
Jun 3
✓
Standards Document (teacher-standards.html)
Illinois Essential Employability Skills, CTE WBL standards, CCSS ELA connections, NAF standard alignment.
Jun 3
Main Field Experience Site
✓
7 Career Cluster Pages
cluster-agriculture/arts/finance/health/human/it/manufacturing.html. Each has a collage hero, about section, and live job cards from Supabase (primary) + Google Apps Script (secondary). Background images hosted on Cloudinary (dikkdclum). Fixed Netlify HTML minification bug that was breaking background images.
May–Jun
✓
Resources Page (resources.html)
Course Expectations (Google Doc), Weekly Hours Log (→ weekly-log.html), Weekly Reflection (→ weekly-reflection.html), Class Calendar embed.
May 29
✓
Positions Page (positions.html)
Teacher-facing business partner review document. Pulls from Supabase job_listings (primary) + Google Apps Script (secondary). Not student-facing.
May 29
Supabase Backend
✓
6 Tables Created
teachers, students, weekly_logs, weekly_reflections, bootcamp_progress, portfolio_items. All have RLS enabled. Students see only their own rows; teachers see all.
May 29
✓
handle_new_user trigger
Auto-creates a row in students table when a new user signs in via Google OAuth. Fixed to use public.students with explicit schema and set search_path = public.
May 30
✓
WBL job_listings table (separate project)
Same Supabase project (bsgrkpykysvqcdqikcym). WBL admin form adds listings, public cards display them on workbasedlearning site. Cluster pages on FE site also pull from this table.
May 23
Pending SQL — Run in Supabase
Add notes column to bootcamp_progress
Required for bootcamp activity submissions to save content
-- Run in Supabase SQL Editor
alter table bootcamp_progress add column if not exists notes text;
alter table students add column if not exists semester_goal text;
alter table students add column if not exists launch_date timestamptz;
alter table students add column if not exists placement_name text;
Add email columns to weekly_logs and weekly_reflections
Stores student name/email on each submission so teacher submissions viewer can display names
alter table weekly_logs add column if not exists student_email text;
alter table weekly_logs add column if not exists student_name text;
alter table weekly_reflections add column if not exists student_email text;
alter table weekly_reflections add column if not exists student_name text;
Cloudinary upload preset for WBL logo uploads
Go to Cloudinary dashboard (dikkdclum) → Settings → Upload → Upload presets → Create preset named "wbl_uploads" (unsigned). Without this, drag-and-drop logo upload on WBL admin form fails. URL paste still works as fallback.
Known Issues / Notes
Google Apps Script must be redeployed after changes
The Apps Script web app that serves job listing data as JSON (for cluster pages fallback) must be redeployed as a new version any time the script is changed. Go to Apps Script → Deploy → Manage deployments → New version.
portfolio_items table not yet used
The portfolio section on the student dashboard shows a placeholder. portfolio.html has not been built yet. The table exists and is ready.
WBL site: middle video was broken (now fixed)
Incubator video was missing from Cloudinary. Uploaded June 3 (70MB → 18MB H.264 optimized). URL updated in index.html. Third video card (Parents) was removed — no video exists for it.
Last updated: June 3, 2026 · fieldexperiencebps101.net