Operations Overview
Live counts across the whole CE2001 platform.
Homepage Content
Edits the tabs the homepage already reads at ?action=homepage. Saving clears the 120-second response cache, so changes are live on the next page load. Leave a field blank and the homepage falls back to the copy printed in the HTML — it never shows an empty section.
Hero
The headline block. These write to the About sheet.
Content tables
Sort decides the order on the page. Published must be yes for a row to appear at all.
Member Portfolio
Awards, publications and projects for one member. Projects with Lat and Lng appear on the map on their profile; those without still appear as cards, labelled “Not mapped”.
Committee Management
Members, mandates, terms & documents — auto-published to the Governance section via the public db_committees feed.
| Committee | Chairperson | Members | Term | Docs | Status |
|---|
Articles — Submission, Review & Publishing
draft → review → approved → published · every save versioned in ArticleVersions · published items feed News / Programs / Awards / AMSAP / Legacy via db_articles.
| Title | Section | Author | Status | v | Updated |
|---|
Certificates & ID Design Studio
The full WYSIWYG studio (templates, dynamic fields, Google Slides → PDF → Drive) lives in the existing consoles; QR verification is live below.
🔍 QR Verification API tester
Endpoint: ?action=ac_verify&id=… — embedded in every issued ID/certificate QR.
Awards & Nomination Panel
Categories, nominees, blind scoring, live consolidation and certificate generation run in the dedicated console (AwardCategories / Nominees / AwardCommittee sheets).
Events & Check-In
Live attendance from the Registration / RSVP / CheckIn sheets.
Membership & Directory Admin
Profile edits, registration approval, credential (re)issuance and directory visibility run in the verification console; payment overrides in the WP dashboard admin tab.
AMSAP Support Confidential
Alumni Mutual Support Assistance Program — visible to Admin & Secretariat roles only. Intake endpoint: db_amsap_submit.
| Case | Requester | Summary | Priority | Status | Handler |
|---|
Legacy Hub & Donor Wall
Pledges, donations and sponsors are managed in the Finance console; the public Donor Wall auto-updates from the same sheets; receipts go out via MailWish (donor_receipt template).
Marketplace Moderation
Approve, feature, or hide alumni business listings. Approval emails the owner via MailWish automatically.
| Business | Owner | Category | Rating | Status |
|---|
Project Impact Map — Verification
Verify submitted projects before they appear on the Global Map and Gallery. Verification emails the submitter via MailWish. Correct coordinates during review if needed.
| Project | Location | Year | Submitter | Pin | Status |
|---|
Edit project
Blank lines start a new paragraph. Lines beginning with • or - become bullet points on the map card.
Officers & Board — Leadership Profiles
Each officer writes their own profile at officer-edit.html using their
edit code. Nothing they write appears on the public site until it is published here. Their name,
role, committee and the association's own description of the role are always shown — the gate
covers what the officer wrote.
| Officer | Group | Written | Updated | Status |
|---|
Review submission
Publishing records who approved it. Any later edit by the officer returns the page to pending — an officer who has been published and then rewrites their page does not skip the second read.
Edit profile
The association's own description
These were never the officer's to set. Changing the group moves their card between Association Officers, Directors at Large and Past Presidents.
What the officer wrote
You are editing text that publishes under this person's name. Correct errors; do not put words in their mouth.
Links must start with http(s) and the file must be shared “anyone with the link”. A line that is not a link is dropped when the page renders, but it is kept here so it can be fixed rather than lost.
Saving does not change whether the page is published. A page that is already live stays live with your correction; a draft stays a draft. Publishing is the button in the review card above, and it records who approved it.
Edit codes
Each officer signs in to their editing screen with their own code. Send each officer only their own. Anyone holding a code can rewrite that officer's profile.
Gallery — Photo Moderation
Alumni uploads land in Drive's _Pending_Uploads and this queue. Approve moves the photo into its album (live within 5 minutes); Reject trashes it. Everything is logged in the UploadLog sheet.
| Photo | Uploader | Album | Caption |
|---|
Why is a photo not showing?
“Photo unavailable” on the public gallery has three possible causes and they look identical from a browser: the file is not shared publicly, Drive has not finished generating its thumbnail, or the file is gone. This asks Drive directly, without credentials — exactly what an anonymous visitor's browser does — so the answer is the visitor's experience, not a guess.
| File | Sharing | HTTP | Verdict | What to do |
|---|
Communications & Email Automation
All mail flows through MailWish (Mail.gs). Queue bulk sends, watch the log, monitor the hourly worker.
📣 Bulk send
⏱ Queue status
Hourly worker drains BulkQueue at ≤ MAIL_HOURLY_LIMIT (MailWish ~300/hr cap).
📜 EmailLog (latest 100)
| Time | To | Subject | Template | Committee | Status | What happened |
|---|
A red error with nothing beside it used to be the whole message. The reason was always recorded — it just was not shown.
Settings & Security
Role-based access · API-key status (values never shown) · full audit trail.
👮 Roles
| Role | Committee | Active |
|---|
Permission matrix — admin: everything · secretariat: all ops except this module · editor: articles + comms · chair: own committee + article submit/review. Chairman/Secretariat from the Awards Committee sheet are admins automatically.
🔌 Endpoints
Where this site sends its requests. Same panel as the one on the sign-in screen.
🔑 API keys (Script Properties)
| Key | Status | Preview |
|---|
Values are write-only — set them in Apps Script → Project Settings. Secrets show last-4 only.
🧾 Audit log (latest 150)
| Time | Who | Action | Detail |
|---|
