Project Prompt
A private educational institution offering professional certificate programs. The process involved multi-step course applications, referee submissions, fee collection, and admin approvals.
Problem
Their previous system relied heavily on manual data collection via Google Forms, emails, and spreadsheets. It lacked real-time tracking, user guidance, and administrative control — leading to incomplete applications and administrative inefficiencies.
Goals
- Streamline the application process into a single, user-friendly portal
- Track completion percentage of each applicant
- Collect and manage referee submissions
- Track fee payments and approval statuses
- Allow admins to review and update application status efficiently
Our Solutions
We built a fully custom web application using React and Supabase, offering the following features:
- User Authentication: Applicants can register, log in, and securely access their dashboard.
- Multi-Step Application Flow: Each section saved progress, visualized with a completion tracker.
- Referee Submission Tracking: Built a centralized system to manage referee submissions and status.
- Fee & Plan Management: Users selected payment plans and fees payment system with stripe integration; status updated automatically.
- Admin Review Tools: Admins could view, search, and mark applications as reviewed/approved.
Outcome
- 100% reduction in spreadsheet/manual tracking
- 80% of applicants completed more of their forms than previous years
- Admin review time was reduced by more than 60%
- A scalable portal now ready for future programs and use cases
