Last Run
—
Click Run Diagnostics to begin
Tests Passed
—
of — total
Script Latency
—
JSONP ping response
Members Loaded
—
from Admin Users sheet
Reservations
—
rows in sheet
Group Rentals
—
rows in sheet
Issues Found
Run diagnostics to check for issues.
Connection & Script Tests
1
Browser Environment
Protocol, online status, and configuration checks
2
Network Reachability
fetch() to Google Apps Script endpoint
3
Script Ping (JSONP)
Verifies the Apps Script is deployed and responding
4
Admin Users Sheet
getMembers — verifies "Admin Users" tab exists and returns names
5
Reservations Sheet
getData — reads the Reservations tab and checks structure
6
Group Rentals Sheet
getData — reads the Group Rentals tab and checks structure
7
Auth Flow Check
Simulates a bad-PIN auth to confirm the endpoint responds correctly
Data Integrity Checks
Run diagnostics first.
How to use this report with AI:
1. Click Generate Report below, then Copy to Clipboard.
2. Open a new chat with Claude (or your AI of choice).
3. Paste the report and add your question — e.g.
4. The report includes full raw responses, timings, and a system snapshot so the AI has everything it needs to diagnose and fix any issue.
For recurring issues: paste the last 2–3 reports together to show the AI a pattern over time.
1. Click Generate Report below, then Copy to Clipboard.
2. Open a new chat with Claude (or your AI of choice).
3. Paste the report and add your question — e.g.
"The getMembers test is failing. What should I check?"4. The report includes full raw responses, timings, and a system snapshot so the AI has everything it needs to diagnose and fix any issue.
For recurring issues: paste the last 2–3 reports together to show the AI a pattern over time.
Report will appear here after running diagnostics and clicking Generate Report.
Run History (this session)
| # | Timestamp | Tests Passed | Members | Res Rows | Rent Rows | Latency | Overall |
|---|---|---|---|---|---|---|---|
| No runs yet. | |||||||
Recommended Maintenance Schedule
Every 2–3 Days
Routine health check. Run all diagnostics, review timings and member count. Generate and save a report if anything looks unusual.
Routine- Run full diagnostics
- Check all tests pass
- Confirm member names load
- Verify Reservations & Rentals row counts match spreadsheet
- Note any latency above 5s
Weekly
Deeper check. Review data integrity, open the spreadsheet directly, confirm no sheet tabs have been renamed or deleted.
Weekly- Run diagnostics + generate report
- Open spreadsheet, verify tab names: Reservations, Group Rentals, Admin Users, Newsletter
- Check Admin Users has active entries
- Confirm no duplicate rows in sheets
- Review any pending reservations
Monthly
Script maintenance. Google Apps Script deployments can expire or need re-authorisation. Re-deploy as a new version monthly.
Monthly- Open Google Apps Script editor
- Deploy → Manage deployments → Edit → New version → Deploy
- Confirm "Execute as: Me" and "Access: Anyone"
- Update SCRIPT_URL in admin/index.html if it changed
- Run full diagnostics after redeployment
- Archive completed/cancelled entries via admin Data tab
If Something Breaks
Run diagnostics immediately, generate a report, and paste it to Claude with a description of what stopped working.
Incident- Run diagnostics — identify which test fails
- Generate report → Copy → Paste to Claude
- Describe what the user saw (e.g. "dropdown stuck on Loading")
- Include any recent changes (renamed sheet, new deployment, etc.)
- Check Apps Script executions log for errors
Common Failure Modes & Quick Fixes
Dropdown stuck on "Loading team…"
Cause: Apps Script not deployed, wrong sheet name, or JS syntax error in admin/index.html.
Fix: Run diagnostics → check Test 3 (JSONP Ping) and Test 4 (Admin Users). Redeploy script if needed.
Cause: Apps Script not deployed, wrong sheet name, or JS syntax error in admin/index.html.
Fix: Run diagnostics → check Test 3 (JSONP Ping) and Test 4 (Admin Users). Redeploy script if needed.
Test 3 fails (JSONP timeout)
Cause: Script not deployed as "Anyone", or deployment URL changed.
Fix: Apps Script → Deploy → Manage → confirm "Who has access: Anyone". Copy new /exec URL into admin/index.html.
Cause: Script not deployed as "Anyone", or deployment URL changed.
Fix: Apps Script → Deploy → Manage → confirm "Who has access: Anyone". Copy new /exec URL into admin/index.html.
Test 4 fails ("Admin Users sheet not found")
Cause: Sheet tab renamed or deleted.
Fix: Open spreadsheet, rename the staff tab exactly to
Cause: Sheet tab renamed or deleted.
Fix: Open spreadsheet, rename the staff tab exactly to
Admin Users (case-sensitive).
Latency above 8 seconds
Cause: Google Apps Script cold start, spreadsheet has too many rows, or script has execution errors.
Fix: Check Apps Script executions log. Archive old completed rows via admin → Data tab.
Cause: Google Apps Script cold start, spreadsheet has too many rows, or script has execution errors.
Fix: Check Apps Script executions log. Archive old completed rows via admin → Data tab.
Configuration
The /exec URL from your Apps Script deployment. Found under Deploy → Manage deployments.
Used in generated reports.
Direct link to the master spreadsheet. Not used in tests — for your reference only.
Used in reports as a reference link.
How long to wait before marking a test as timed out. Default: 15000ms (15 seconds).