Multi-User Booking System with Calendar Sync & Stripe Payments by Snehal ParateMulti-User Booking System with Calendar Sync & Stripe Payments by Snehal Parate
Multi-User Booking System with Calendar Sync & Stripe Payments
The objective was to create a "source of truth" for busy professionals. The platform needed to handle complex multi-tenancy, secure payment routing, and real-time synchronization with external calendar providers (Google and Outlook) to ensure Admins never missed a booking made through their embedded service widgets.
Key Technical Milestones
1. Integrated Calendar Synchronization
I implemented a seamless connection between the platform and major calendar providers to eliminate scheduling conflicts.
Unified Availability: Admins can choose to connect their Google or Outlook accounts. The platform then intelligently cross-references existing external appointments with platform bookings to provide a "universal" availability view.
Real-Time Updates: As soon as a booking is confirmed on the platform, it is automatically pushed to the Admin’s connected professional calendar, ensuring their schedule is always up to date across all devices.
2. Dynamic Intake & Questionnaire Builder
Built a flexible data-collection engine that allows Admins to create custom forms for each service.
Dynamic Rendering: Used JSONB storage in Supabase to power a dynamic form generator in WeWeb, allowing for custom fields (Text, Select, etc.) that end-users fill out during the booking process.
3. Advanced Multi-Tenant Logic & Availability
Granular Control: Admins can define specific work weeks (e.g., Mon–Sat) and set "look-ahead" windows to restrict how many days into the future a service can be booked.
Data Isolation: Leveraged Supabase Row Level Security (RLS) to ensure complete data privacy between different business accounts.
4. Monetization & Payment Routing
Stripe Connect Integration: Implemented a system where services can be toggled between "Paid" and "Free."
Direct Payouts: Funds are routed securely through Stripe Connect directly to the Admin’s account, supporting a true SaaS marketplace model.
5. Automated Reminder Engine
Developed a background notification service using Supabase Edge Functions to send automated email/SMS reminders, successfully reducing no-show rates for all tenants.