Spaces:
Sleeping
Sleeping
Commit History
-
Add a Sheet publisher script that works for any university
Donne120 +1: Claude Opus 5Code.gs is ALU's bespoke publisher: TAB_CONFIG hardcodes that sheet's tab names, its header rows (row 2 on one tab, row 7 on another), and even a misspelled `discription` column. Pasted into another university's sheet it matches none of those tab names and publishes zero entries — silently, because unconfigured tabs are skipped rather than reported. Onboarding a university therefore meant an engineer rewriting TAB_CONFIG by hand, which is exactly the bottleneck the per-organization sheet work was meant to remove. UniversityTemplate.gs needs no editing. It searches the first ten rows for a header (so a title banner above the columns doesn't break it), matches column names by meaning rather than exact spelling — Question / Title / Topic all resolve to the same field — reads every tab, and skips ones whose names look internal (workplan, draft, scratch). previewPayload() reports per-tab counts so a zero result is diagnosable rather than mysterious. Verified against ten sheet shapes a uni…13d7de0
-
sheet_sync: disambiguate duplicate entry ids within a batch
Donne120392a0c4 -
Wire Google Sheet knowledge base into Claude RAG
Donne120eaa56f0