Admin Control Center

Checking your sign-in…

Sign in with an access token instead

Only needed if your WordPress account cannot be used — for example while the site's own settings are what needs fixing. Requires CE2001_LEGACY_ACCESS_CODES=1 in Apps Script.

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.

Preview homepage ↗

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.

CommitteeChairpersonMembersTermDocsStatus

Articles — Submission, Review & Publishing

draft → review → approved → published · every save versioned in ArticleVersions · published items feed News / Programs / Awards / AMSAP / Legacy via db_articles.

TitleSectionAuthorStatusvUpdated

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.

Open Design Studio →Alumni ID & Certificate templates, presets, PDF generation to Drive (Designs / Certificates sheets) Awards certificate designer →Award-category certificate templates & batch issuance

🔍 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.

CaseRequesterSummaryPriorityStatusHandler

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.

BusinessOwnerCategoryRatingStatus

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.

ProjectLocationYearSubmitterPinStatus

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.

OfficerGroupWrittenUpdatedStatus

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.

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)

TimeToSubjectTemplateCommitteeStatusWhat 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

EmailRoleCommitteeActive

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)

KeyStatusPreview

Values are write-only — set them in Apps Script → Project Settings. Secrets show last-4 only.

🧾 Audit log (latest 150)

TimeWhoActionDetail

Committee

Shown as the heading on the Officers & Board page.

One or two sentences. This is the description under the committee on the public page.

One per line: Name | email | role. The email and role are optional — a line with just a name is kept. Only names and roles appear on the public page; email addresses stay in this console.

A line without a working http(s) link is dropped.

Archiving takes a committee off the public page and keeps its member list. Nothing here deletes a record.

Article

Version history

AMSAP Case Confidential