Simple, secure onboarding
People can register or confirm their information through QR codes and a secure code sent to them—no password to remember.
Private product · Case study2026
From weekly spreadsheetsto actionable community care.
I designed and built a secure platform that connects member registration, youth service attendance, study groups, and follow-up—giving the ministry reliable information to care for its community and plan with context.
- Role
- End-to-end engineer
- Scope
- Product · UX · Frontend · Backend
- Status
- Private production system
The product
A command center for attendance and community follow-up.
The dashboard brings together active members, study groups, youth service attendance, and people who may need follow-up—giving leaders a clear view of where to act first.
The starting point
Attendance lived in Excel, but the questions were bigger than a weekly count.
The youth ministry needed attendance data to understand participation and improve its services. The first step was a spreadsheet updated every week, but as records accumulated it became difficult to access, maintain, and use consistently.
A total count could not answer who was attending study groups but missing services, who had been absent repeatedly, or where a closer personal follow-up was needed.
A clearer path from registration to follow-up.
Two attendance histories
The platform records youth service and study-group attendance separately, then brings both views together.
Follow-up that starts with context
Leaders can see each person’s history and identify recurring absences before deciding how to follow up.
Community coordination
Roles, reminders, weekly reports, birthdays, and celebrations are managed from the same system.
Connected information
One profile connects attendance, groups, and follow-up over time.
Instead of creating a separate list every week, each new attendance record becomes part of the person’s history. Leaders can understand participation across activities without searching through multiple files.
CORE RECORDPersonProfile · contact · birthday
What changed
Attendance became useful context, not just stored data.
One reliable record
Member information and attendance no longer depend on separate weekly files.
A complete history
Each person’s participation can be understood across services and study groups.
Clear follow-up signals
Patterns of absence become visible so leaders know where a personal conversation may help.
Better-informed planning
The ministry can use consistent records to evaluate activities and plan upcoming services.
How information stays protected
Access is designed around each person’s responsibility.
SIGN INSecure access code→INFORMATIONOne central record→PERMISSIONSAccess by responsibility→COMMUNICATIONAutomatic reminders
People enter with a one-time code. From there, permissions determine which member records and actions each responsibility can access, keeping sensitive information away from those who do not need it.
Technology usedNext.js · Supabase · PostgreSQL · Resend
Beyond attendance
A connected digital ecosystem for the community.
Public website
generacionejemplo.comThe public home for the ministry, its identity, and its activities.
Visit website ↗Community operations
asistencia.generacionejemplo.comThe private attendance and follow-up platform. Direct access is not provided because it contains confidential member information.
PRIVATE · SHOWN WITH DEMO DATABand planning
A supporting tool for organizing songs and preparing playlists for ministry bands.
Live camp quiz
An offline-friendly multiplayer quiz for camp activities.