First time setup (AV member)

1. Open service.tjc.org.au/select-church
2. Select your church from the dropdown (e.g. Melbourne)
3. Click Continue — your choice is saved on this computer
4. You're taken to the main app — sermon data loads automatically

Service day workflow

1. Open service.tjc.org.au on the control laptop
2. Open service.tjc.org.au/projector.html on the projector display
3. Verify today's sermon title appears in the Sermon tab
4. During service — use Hymns tab for hymn lyrics, Bible tab for verses
5. Slides tab for announcements and special slides

Changing your church selection

1. Go to service.tjc.org.au/select-church
2. Click Clear saved church selection
3. Select a different church and click Continue

System Overview

Internet
    │
    ▼
service.tjc.org.au (Cloudflare DNS / Synology reverse proxy)
    │
    ▼
Proxmox CT102 — Ubuntu LXC
    ├── Python HTTP Server (port 9000)
    │     ├── Serves React SPA (index.html + assets)
    │     ├── Serves projector.html
    │     ├── GET /api/sermon  → Google Sheets API
    │     ├── GET /api/churches → church list
    │     └── POST /api/set-title → localStorage push
    │
    ├── config.json  (Sheet ID, column mapping, churches)
    ├── service-account.json  (Google auth — admin only)
    └── assets/  (cached JS/CSS/hymn data from CloudFront)

Data Flow — Sermon Auto-fetch

AV computer browser
  → GET /api/sermon?church=Melbourne
  → CT102 server reads config.json (Sheet ID, columns)
  → Server uses service-account.json to get Google OAuth token
  → Calls Google Sheets API v4 (private, authenticated)
  → Finds today's row by date/time
  → Returns: { title, ch_title, speaker, interpreter, hymns }
  → Browser displays in Sermon tab

Offline Capability

All hymn JSON files (1–500) and Bible data are cached locally in /assets/data/ on first load. Once cached, hymns and Bible work without internet. Only sermon data requires internet (Google Sheets API).

Before service

1. Turn on projector and set input to the AV computer's HDMI
2. Open Chrome/Edge on the AV computer
3. Navigate to service.tjc.org.au
4. Click Hymns tab — verify hymn numbers match the service sheet
5. Click the Projector button — a popup opens showing what displays
6. Drag the popup window to the projector screen and maximise it

During service

What to display	Where to go
Hymn lyrics	Hymns tab → select hymn → click verse
Bible verse	Bible tab → select book/chapter/verse
Sermon title	Sermon tab → shows automatically
Announcements	Slides tab
Clear screen	Click the X / blank button

How church selection works

Each AV computer selects its church independently. The selection is saved in the browser's local storage — it persists between visits and browser restarts, but is specific to that computer and browser.

To select / change your church

1. Go to service.tjc.org.au/select-church
2. Pick your church from the list
3. Click Continue

To clear selection

1. Go to service.tjc.org.au/select-church
2. Click Clear saved church selection at the bottom

This only clears the church selection — no other data is affected.

Opening the projector

In the app, click the Projector/Output button. A separate popup window opens — this is what goes on the projector. Move it to the second screen and press F11 or maximise it.

If the projector popup closes unexpectedly

1. Click the Projector button again in the main app
2. If Chrome is blocking popups: click the popup icon in the address bar → Allow

Direct URL option

You can also open the projector directly by navigating to service.tjc.org.au/projector.html in a separate browser window — useful if you want to use a separate device as the projector display.

Accessing the Admin Panel

1. Go to service.tjc.org.au/admin
2. Enter the Admin PIN (default: 1234 — change this immediately)

Adding churches

1. Admin → Server tab → Churches
2. Add each church name exactly as it appears in the Google Sheet tab
3. Save — the church appears in the AV member dropdown at /select-church

Configuring Google Sheets

See the Google Sheets guide.

Uploading service-account.json

1. Open Filebrowser at 192.168.178.169:8080 (LAN only)
2. Drag service-account.json into the app folder
3. Restart: systemctl restart tjc-service

Required Google Cloud setup

1. Go to Google Cloud Console
2. Create a project → Enable Google Sheets API
3. IAM → Service Accounts → Create → name it tjc-service-reader
4. Keys tab → Add Key → JSON → download the file
5. Copy the service account email (ends in @...iam.gserviceaccount.com)
6. Share the SermonTitles sheet with that email as Viewer
7. Upload service-account.json via Filebrowser

Sheet column layout

Column	Field	Example
A	Date	27/03/2026
B	Day	Friday
C	Time	8:00 PM-9:00 PM
D	Sermon Speaker	Bro. Ferry Teja
E	Interpreter	Sis. Yvonne Lim
F	Sermon Title (English)	Waiting for God's Timing
G	Sermon Title (Chinese)	等候神的时间
H	Starting Hymn	3
I	Ending Hymn	144

How sermon matching works

The server reads all rows and finds the one closest to now that is either upcoming or within 3 hours in the past (covers services in progress). If no upcoming service is found, it returns the most recent past service.

Available profiles

Profile	Global BG	Accent	Panel BG	Used by
Melbourne	#534948 (warm brown)	#c7694c (orange)	#d9d9d9 (grey)	Melbourne TJC
Dark	#000000	—	#000000	Generic dark
Navy Blue	#1a2744	#c9a84c (gold)	#f0f0f0	—
Clean White	#ffffff	#0066cc	#ffffff	—

Applying a profile

1. Go to /admin → Display tab
2. Select a profile card
3. Click Apply Profile to App
4. The projector screen updates immediately (refresh if needed)

Import your own settings

Export settings from the live service.tjc.org app using their export function, then import the JSON file in Admin → Display → Import.

GET /api/sermon

Returns today's sermon data for a given church.

Query Parameters

Param	Required	Description
church	No	Church tab name. Falls back to server default if not provided.

Example Request

GET /api/sermon?church=Melbourne

Example Response

{
  "date": "03/04/2026",
  "time": "8:00 PM-9:00 PM",
  "title": "Waiting for God's Timing",
  "ch_title": "等候神的时间",
  "speaker": "Bro. Ferry Teja",
  "interpreter": "Sis. Yvonne Lim",
  "hymns": "3, 144",
  "church": "Melbourne"
}

GET /api/churches

Returns the list of configured churches.

{
  "churches": ["Melbourne", "Sydney", "Brisbane"]
}

POST /api/set-title

Push sermon data directly to the projection screen.

POST /api/set-title
Content-Type: application/json

{
  "title":    "Grace of God",
  "ch_title": "神的恩典",
  "hymns":    "123, 456"
}

GET /api/settings

Returns current server configuration (API key masked).

POST /api/settings

Save server configuration.

Problem	Cause	Fix
Sermon data not loading	service-account.json missing or wrong	Check Admin → Server tab. Re-upload JSON via Filebrowser.
Title is blank	Speaker hasn't entered title in sheet yet	Normal — title shows once entered in the spreadsheet
Wrong church loaded	Church selection mismatch	Go to /select-church → Clear → re-select
Projector popup closes	Browser blocking popups	Allow popups for service.tjc.org.au in browser settings
Hymn not found	Data not cached yet	Need internet for first load. Once cached, works offline.
Site not loading	CT102 or Synology offline	Check Proxmox — systemctl status tjc-service
Caller does not have permission	Sheet not shared with service account	Share sheet with service account email as Viewer

Restarting the service

systemctl restart tjc-service
systemctl status tjc-service

Viewing live logs

journalctl -u tjc-service -f