Project 02 · Website + workers’ portal · full-stack

JFCM Santo Tomas

A public website and a workers’ portal for a church ministry. Each account sees only the parts it is allowed to.

Role
Solo full-stack developer, AI-assisted
Platform
Web: public site + workers’ portal
Stack
Next.js · Supabase · TanStack Query
Live
jesusfirststb.com ↗
1234
  1. 1
    Role-based accessEach account sees only what it’s allowed to
  2. 2
    Members & attendanceSchedules, events, tasks
  3. 3
    Financial recordsOnly finance can read them
  4. 4
    QR name tagsScanned by the Android app
01

Why I built it

I noticed everyone had to keep scrolling through group chats just to check their schedules. So I built a schedule builder. Then I added member records so the data is easy to find, and it kept growing from there: attendance, an events calendar, Bible studies, a tasks board, monthly progress reports, printable QR name tags, encrypted financial records, push notifications, and more. Now each member sees all of their schedules on their profile: one page for the whole month.

02

What it does

  • Public websiteEvents calendar, announcements, ministries and Mission Fields, all edited from the portal with image upload and cropping.
  • Members & attendanceMembers, visitors and milestones. Attendance from the web or the Android scanner, and printable QR name tags.
  • SchedulesA schedule builder with templates for every service, plus the monthly Simbahay schedule. Workers get a notification when they're assigned.
  • My ProfileEach member sees all of their schedules for the month on one page.
  • Bible studies & teachingsBible study groups, and a teachings library for workers with PDFs and drafts.
  • Planning & reportsA tasks board with activity history and agenda notes, the monthly progress report, and printable monthly calendars.
  • FinancialA monthly financial sheet that exports to Excel, encrypted and readable only by people with the finance grant.
  • Accounts & accessThe same account as Liriko, permissions per area (view, add, edit, delete), and an email code on every sign-in.
03

Stack

  • TypeScript
  • React
  • Next.js
  • Tailwind CSS
  • Supabase
  • PostgreSQL
  • SQL
  • TanStack Query
  • Jest