CASE STUDY
From Excel & WhatsApp
to a Native App.
How I built a scheduling and communication app for my church usher team, starting with an Excel spreadsheet and a WhatsApp group and ending up in the App Store.
The Situation
I serve on the usher team at Community Family Church (CFC). Before this app existed, our team ran on two tools: an Excel spreadsheet and a WhatsApp group chat.
Each month, the schedule coordinator would build the roster in Excel, screenshot it, and post it to the WhatsApp group. It worked, but it had real friction. The image would get buried in the message thread, and anyone who wanted to know when they were scheduled had to scroll back through the conversation just to find the picture. Announcements lived in the same group chat as everything else, so they got lost too.
The team was doing great work. The tools just weren't built for it. I wanted to streamline the process and give everyone a cleaner, easier way to see their schedule and stay connected without having to hunt through a group chat.
THE INSIGHT
"I wasn't building something I imagined a church might need. I was building something I needed, and I knew exactly where the friction was because I felt it firsthand."
— Jason Needham, Developer & CFC Usher
The Decision to Build
Generic scheduling apps exist, but they're designed for shift workers and retail teams. They don't understand volunteer culture, ministry roles, or the specific rhythm of a church service. And none of them combined scheduling, communication, and team management in a way that made sense for a small volunteer team.
So I built it from scratch. What started as a simple web app to replace the Excel screenshot grew, phase by phase, into a full native iOS and Android application that the team uses every week.
How It Was Built
The app was built incrementally, with each phase solving a specific problem the team was experiencing. No feature was added speculatively. Everything came from real usage.
Phase 1
Schedule & Member Management
Monthly schedule calendar with per-member shift views, Excel import/export, admin approval flow for new member registrations, role-based access (Standard, Admin, Super Admin), and member suspension controls.
Phase 2
Announcements
Admins post pinned announcements with push notifications on publish. Members see them pinned on their dashboard so nothing gets buried in a group chat. Weekly email digest every Monday morning.
Phase 3
Real-Time Team Chat
Socket.io-powered group chat organized into ministry-specific channels (General, Prayer, Leadership, etc.). Full support for images, GIFs, PDFs, link previews, emoji reactions, edit/delete, and keyboard-safe layout on both platforms.
Phase 4
Direct Messaging
Private 1-on-1 and group DM threads with full parity to channel chat. Unread indicators, push notifications targeted only to conversation participants, and a compose modal to start new threads from the team directory.
Phase 5
Native iOS & Android App
Rebuilt from a PWA into a full native app using React Native (Expo). Published to the App Store and Google Play with over-the-air (OTA) updates so most changes don't require going back through App Store review.
Phase 6
Admin Dashboard
A central place for leadership to manage the team. Approve new registrations, manage member roles, reset passwords, and see who has been active. Everything in one place instead of scattered across emails and spreadsheets.
What It Replaced
BEFORE
Excel screenshot in WhatsApp
AFTER
Push notification the moment the schedule drops. Each member sees only their own shifts.
BEFORE
WhatsApp group chat for all communication
AFTER
Organized channels by topic, plus private 1-on-1 DMs. Important messages no longer get buried.
BEFORE
No way to reach one person privately
AFTER
Direct messaging with unread indicators, push notifications, and full chat features.
BEFORE
Training docs emailed or printed
AFTER
PDFs uploaded and assigned to specific members, accessible in the app anytime.
BEFORE
Announcements lost in group chat
AFTER
Pinned announcements with push notifications and expiration dates, always visible on every member's dashboard.
BEFORE
No central place to manage the team
AFTER
Admin dashboard for approvals, role management, and member oversight. Leadership has a clear view of the team.
Tech Stack
The Outcome
The CFC usher team uses the app every week. Schedules are delivered automatically with push notifications. Members see their shifts the moment the schedule is published. No screenshot, no WhatsApp post, no scrolling through messages.
Leadership communicates through organized channels instead of one big group chat. New ushers can find training documents right in the app. The admin dashboard gives leadership a clear view of the team that just wasn't possible before.
Download the App
CFC Ushers is live on the App Store. Android coming soon.
COMING SOONInterested in building something like this? Get in touch.
Jason Needham · jneedham@needhamtechstudio.com · (859) 444-0394