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
- 1Role-based accessEach account sees only what it’s allowed to
- 2Members & attendanceSchedules, events, tasks
- 3Financial recordsOnly finance can read them
- 4QR 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
Next project · 03