Back to Home
Flagship Case Study · Digital Operations Platform

DUMC CN Children Church Platform

A production-grade platform that runs the daily operations of a large children's ministry — secure child check-in, real-time attendance analytics, an append-only rewards economy, and an automated, multi-constraint volunteer scheduling engine. Fully bilingual, serving five distinct roles, and installable-free on any device.

Visit Live Site
60+
Pages across 5 roles
75+
REST API endpoints
100+
Schema migrations
5
Distinct user roles
2
Languages (EN / 中文)
3
Front-end apps, one backend

The Challenge

A live children's church ministry ran on paper sign-in sheets, spreadsheets, and manual roster planning — across children, parents, teachers, counter staff, and administrators. Attendance was hard to analyse, duty rosters took hours to plan by hand, and there was no way to motivate and reward consistent participation. They needed one cohesive, bilingual platform that every role could use on any device — no app store, no IT department.

What We Built

A single Progressive Web App serving five distinct roles, each with a tailored dashboard and permission-gated routes — plus a companion Android check-in app sharing the same cloud backend.

Multi-role access & auth

Firebase Google OAuth for staff; phone-OTP with sliding-session tokens for parents; a kid-friendly login for children. Five roles — admin, teacher, event admin, counter staff, parent/child.

Attendance & analytics

QR-code self check-in stations and manual entry, with per-child and per-teacher analytics, trends, and exportable reports. Walk-in registration counts toward attendance.

Gamified discipleship

A stamp & prize economy with an append-only ledger, monthly redemption windows, daily caps and pre-booking; a drag-and-drop Memory Verse challenge with video submissions; and a teacher Growth Path (信徒成长之旅).

Duty roster & scheduling

Auto-generates 13-week quarterly serving rosters across two age bands with a constraint-aware engine (sibling stacking, parent-teacher pairing, eligibility pools, slot caps) and drag-and-drop manual adjustments.

Registration & events

Online student & volunteer registration with digital signature capture and a review/approval pipeline; event creation, self-check-in stations, media galleries and rosters.

Admin operations

Announcement broadcasting, a contact-message inbox, training attendance, role/room management, name-card export, a links CMS, and a Gemini-powered AI assistant chat.

Engineered for Complex Operations

Every screen solves a real operational headache — here's what's happening under the surface.

Bilingual by design — every screen in English and 中文
Bilingual by design — every screen in English and 中文
Real-time attendance analytics — spot trends and export reports in one click
Real-time attendance analytics — spot trends and export reports in one click
Real-time attendance analytics — spot trends and export reports in one click
Automated QR check-in — eliminates queues and manual error
Automated QR check-in — eliminates queues and manual error
Automated QR check-in — eliminates queues and manual error
Append-only rewards economy — tamper-proof points and redemptions
Append-only rewards economy — tamper-proof points and redemptions
Append-only rewards economy — tamper-proof points and redemptions
Engagement that sticks — a gamified memory-verse challenge
Engagement that sticks — a gamified memory-verse challenge
Engagement that sticks — a gamified memory-verse challenge
Smart scheduling engine — auto-builds multi-week rosters around real-world rules
Smart scheduling engine — auto-builds multi-week rosters around real-world rules
Smart scheduling engine — auto-builds multi-week rosters around real-world rules

One Platform, Two Languages

Every screen works in English and 中文 — here's the same view in both.

English
English
English
中文
中文
中文

Hard Problems Solved

The kind of engineering that separates a prototype from a system a ministry can run on.

Constraint-based scheduling

A roster engine that satisfies sibling stacking, parent-teacher pairing, role-eligibility pools and slot caps — then stays editable by hand.

Append-only point economy

A tamper-resistant ledger for stamps and redemptions, with monthly windows, daily caps and a reservation flow — auditable by design.

Timezone-correct datetime

UTC on the backend, Malaysia local on the front — no off-by-one days in attendance, streaks or redemption windows.

Bilingual throughout

Full English / 中文 i18n across 60+ pages and 5 roles — every screen, every report, in both languages.

The Stack

The same technologies we use across every SteadyHand build.

Frontend
React 19 · TypeScript · Vite · Tailwind CSS · React Router 7
Backend
Node.js 20 · Express · MySQL 8 (Cloud SQL) · 75+ REST endpoints
Infrastructure
Google Cloud Run · Cloud SQL · Firebase Auth · Google Cloud Storage
AI
Google Gemini — assistant chat, content analysis, ISBN/verse lookup
Notable libraries
dnd-kit · Recharts · ZXing · FingerprintJS · libphonenumber

One backend serves three front-end apps — the children's church platform, a church Library system, and an Android check-in app — a real multi-tenant service architecture.

Why It's Portfolio-Worthy

Have a system only you can imagine?

If we can build this for a children's church, imagine what we can build for your organization. Talk directly to the engineers — no salespeople.

Chat with us on WhatsApp