CareConnect

Smart activity registration for community care

Comment

Inspiration

During the opening kickoff, we learned that staffs spend 8+ hours every week manually managing activity registrations across Google Sheets, Google Docs, and Canva. Participants accidentally double-book themselves because there's no unified system. Volunteers get assigned to activities they have no interest in, leading to increasing no-show rates. We realized this wasn't just an inefficiency problem, it was stealing time from what matters: engaging with participants and improving their quality of life.

The problem is real: Activity coordinators become data entry clerks instead of community builders.

What We Learned

Technical Growth:

  • Building real-time conflict detection across overlapping time slots required careful database design with PostgreSQL triggers and indexed queries
  • Implementing a smart volunteer matching algorithm that weighs multiple factors (interests, availability, ratings, experience) to generate actionable match scores
  • Integrating Telegram Bot API with a RESTful backend while maintaining session state across conversation flows

User-Centered Design:

  • The best UX is invisible, conflict detection should prevent problems before users encounter them
  • Different user types need radically different interfaces: Telegram for participants (low friction), web dashboard for staff (high control)
  • Real-time feedback matters: showing "3/15 spots left" creates urgency and reduces no-shows

Domain Knowledge:

  • Community care has unique constraints: accessibility needs, caregiver coordination, varying membership types
  • Volunteer retention depends heavily on interest alignment—a 85% match score means someone will actually show up
  • Notifications must respect quiet hours and user preferences while ensuring critical messages always get through

How We Built It

Architecture: We built a full-stack solution with three main components:

  1. Backend API (Next.js + TypeScript)

    • RESTful API with JWT authentication and role-based access control
    • Supabase database with optimized indexes for conflict detection queries
    • Redis caching for session management and frequently accessed data
    • Automated reminder system using node-cron for scheduled notifications

  2. Telegram Bot (Python + python-telegram-bot)

    • Conversational interface for participants, caregivers, and volunteers
    • Session state management for multi-step registration flows
    • Real-time conflict detection during booking attempts
    • Automated notifications for reminders, cancellations, and waitlist offers

  3. Staff Dashboard (Next.js + TypeScript + Tailwind CSS)

    • Real-time metrics and analytics with Recharts
    • Smart volunteer matching interface showing ranked candidates
    • Calendar view with react-big-calendar for visual scheduling
    • Responsive design for mobile access during on-site check-ins

Key Technical Decisions:

  • Used TypeORM for type-safe database operations with automatic migrations
  • Implemented database triggers to maintain booking/volunteer counts automatically
  • Designed the volunteer matching algorithm as a scoring system (0-100) based on weighted factors
  • Separated concerns: Telegram bot handles user interaction, backend handles business logic, dashboard handles staff operations

Integration Points:

  • Supabase for additional data storage and real-time features

Impact & Results

What We're Proud Of:

  • Real conflict detection that actually prevents problems
  • Smart algorithm that staff trust for volunteer suggestions
  • Clean, maintainable codebase with proper error handling
  • Comprehensive documentation for future developers

What's Next

Immediate Roadmap:

  • Complete volunteer rating system (staff rates volunteers after activities)
  • Add activity cloning and templates for recurring events
  • Implement waitlist auto-processing with expiry notifications
  • Build check-in mobile interface for on-site attendance

Future Vision:

  • AI-powered activity recommendations based on participation patterns
  • Integration with other platforms (WhatsApp Business API, LINE)
  • Multi-language support for diverse communities
  • Analytics dashboard for program effectiveness insights
  • API for third-party integrations (existing care management systems)

CareConnect Hub proves that good technology doesn't just automate. Staffs aren't just saving 6 hours per week; they are reclaiming time to do what they love: building community and enriching lives.

Built With

Share this project:

Updates