RLC Centralized Management Platform

• 

• 

Inspiration

When we first learned about the Redwood Region Logging Conference, we were struck by their incredible 85-year legacy of supporting timber education. Here's an organization that has been empowering students and industry professionals since 1938, distributing $70,000 annually in scholarships and hosting events for thousands of attendees - yet they were still managing everything through manual spreadsheets.

The turning point came when we discovered that over 1,200 elementary students participate in their Education Day program, but there was no efficient way to track participation or measure long-term educational impact. We realized that by modernizing their data management, we could help amplify their mission exponentially.

What it does

The RRLC Centralized Management Platform provides a complete scholarship management system for the Redwood Region Logging Conference. Our platform includes:

Scholarship Administration: Admin dashboard for creating and managing scholarship programs with custom application forms, deadline tracking, and flexible award amounts. Includes dynamic form builder with various field types and conditional logic.

Application Management: Complete application review system where administrators can view submissions, update application status (draft, submitted, under review, approved, rejected, awarded), and track award amounts and dates.

User Management: Role-based authentication system supporting admin and applicant roles, with user profile management and secure login/registration.

Dynamic Forms: Built-in form builder allowing admins to create custom application forms with various field types including text, select, file uploads, and conditional fields based on program requirements.

Application Tracking: Students can submit applications through a multi-step form process, upload required documents, and track their application status through a personal dashboard.

The platform replaces manual Excel tracking with a modern web application that provides secure data storage, automated workflows, and comprehensive application management.

How we built it

We built the platform using modern web technologies focused on reliability and user experience:

Frontend: React with Next.js 15 using the App Router for server-side rendering and optimal performance Backend: Supabase providing PostgreSQL database, authentication, and real-time features Database: PostgreSQL with Row Level Security for data protection and user isolation Styling: Tailwind CSS for responsive design and consistent UI components Deployment: Vercel for automatic deployments and scaling

Our database schema centers around three core tables:

-- Users and roles
CREATE TABLE profiles (
  id UUID REFERENCES auth.users PRIMARY KEY,
  email TEXT UNIQUE,
  full_name TEXT,
  role TEXT DEFAULT 'applicant' CHECK (role IN ('admin', 'applicant', 'reviewer'))
);

-- Scholarship programs
CREATE TABLE scholarships (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  name TEXT NOT NULL,
  description TEXT,
  amount DECIMAL(10,2),
  deadline DATE,
  status TEXT DEFAULT 'active'
);

-- Applications with embedded form data
CREATE TABLE applications (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  scholarship_id UUID REFERENCES scholarships(id),
  applicant_id UUID REFERENCES profiles(id),
  status TEXT DEFAULT 'draft',
  -- Form fields for personal and academic information
  first_name TEXT,
  last_name TEXT,
  email TEXT,
  school TEXT,
  gpa DECIMAL(3,2)
);

Challenges we ran into

Dynamic Form Validation: Creating a flexible form system where different scholarships could have different required fields was complex. We solved this by building a dynamic form renderer that validates fields based on scholarship-specific requirements and conditionally shows/hides fields based on user input.

Application State Management: Managing the multi-step application process with draft saving and form validation across steps required careful state management. We used React hooks and context to maintain form state while allowing users to save progress and return later.

File Upload Handling: Implementing secure file uploads for application documents required integrating Supabase Storage with proper access controls and file type validation to ensure only authenticated users could access their own uploaded documents.

Role-Based Access Control: Ensuring proper separation between admin and applicant functionality required implementing Row Level Security policies in Supabase and building protected route components that verify user permissions before allowing access to sensitive areas.

Accomplishments that we're proud of

Complete Scholarship Management System: Built a fully functional platform that handles the entire scholarship lifecycle from program creation to application review and award tracking.

User-Friendly Interface: Created intuitive dashboards for both administrators and applicants with clean, responsive design that works well on desktop and mobile devices.

Dynamic Form Builder: Implemented a flexible form creation system that allows admins to customize application requirements for different scholarship programs without requiring code changes.

Secure Data Handling: Properly implemented authentication, authorization, and data protection ensuring applicant information remains secure and only accessible to authorized personnel.

Real-World Ready: Built with production considerations including error handling, loading states, data validation, and a robust database schema that can scale with RRLC's needs.

What we learned

Full-Stack Development: Gained hands-on experience building a complete web application from database design through user interface, learning how different pieces of the technology stack work together.

Database Design: Learned to design relational database schemas that balance flexibility with data integrity, especially for dynamic form systems that need to accommodate varying requirements.

User Experience: Discovered the importance of thinking from both administrator and end-user perspectives when designing workflows, ensuring the platform serves both types of users effectively.

Authentication & Security: Implemented proper user authentication and role-based access control, learning about security best practices for protecting sensitive applicant data.

Real-World Problem Solving: Working with an actual nonprofit organization taught us how to translate real operational needs into technical requirements and build solutions that genuinely improve existing workflows.

What's next for RRLC Centralized Management Platform

Reporting Dashboard: Add analytics and reporting features to help RRLC track scholarship program effectiveness, application trends, and award distribution over time.

Email Integration: Implement automated email notifications for application status changes, deadline reminders, and award announcements to improve communication with applicants.

Document Management: Enhance file upload capabilities with document preview, annotation tools, and organized storage to streamline the application review process.

Mobile Optimization: Further optimize the mobile experience and consider developing a companion mobile app for easier access during events and on-the-go application management.

Integration Capabilities: Build APIs and webhook support to integrate with RRLC's existing systems and future tools they may adopt for event management and member communications.

Built With

• next.js-15
• react-19
• supabase-(postgresql-+-auth)
• tailwind-css
• typescript