RoC 3 Min Lip Clinic - Event Booking Platform
A production-ready event management and booking system built for RoC Beverly Hills' pop-up lip clinic experiences. This full-stack TypeScript application handles complex multi-day event operations with progressive time window releases, automated dual-channel notifications (SMS + Email), real-time kiosk check-ins, and comprehensive administrative analytics. Designed to manage high-volume appointment booking with 3 simultaneous appointments every 20 minutes while preventing double-bookings through atomic transactions and hold mechanisms. Features a futuristic "Runway Energy" design aesthetic with chrome gradients and custom typography.
Key Features
- •Multi-day event management with complete data isolation between event dates
- •Progressive time window releases with automated waitlist notifications
- •Atomic booking transactions with 15-minute hold mechanism to prevent double-booking
- •Dual-channel notification system using Twilio SMS and SendGrid email
- •Automated reminder scheduler sending 24-hour and 2-hour appointment reminders
- •Real-time admin dashboard with comprehensive KPIs across single days or date ranges
- •Public kiosk mode for on-site check-ins with search by name, email, or phone
- •Special guest management system with tiered badges (Influencer, Media, HCP)
- •Walk-in registration with intelligent reconciliation tools for duplicate detection
- •Self-service check-in portal with 2-hour pre-appointment window
- •Social sharing integration with platform-specific UTM tracking
- •Contact list export with email-based deduplication across all data sources
- •Dynamic Open Graph meta tags for rich social media previews
- •CSV upload system for bulk special guest imports
- •Advanced analytics with appointment status tracking and check-in rates
Implementation Details
This full-stack TypeScript application demonstrates expertise in complex event management systems. Built with React 18 and Express.js, it leverages PostgreSQL with Drizzle ORM for type-safe database operations. The booking engine implements sophisticated slot generation algorithms with timezone conversion to ensure appointments correctly associate with their event day. A 15-minute booking hold mechanism prevents race conditions, with automated cleanup of expired holds. Progressive time window releases are managed by a scheduler service that polls every minute to activate windows and notify waitlists via SMS and email. The admin dashboard uses TanStack Query with optimistic updates and real-time polling for instant feedback. Authentication leverages Replit Auth's OpenID Connect with Passport.js, while the notification service integrates Twilio and SendGrid with comprehensive error handling. The kiosk interface provides an unauthenticated public endpoint for on-site operations with search and instant check-in capabilities.