Med Spa Treatment Timeline Manager

Med spas doing $500k-5M annual revenue with a real patient roster (200+ active patients). Ideal target: practices currently using a patchwork of separate tools, a scheduling system (Mindbody/Aesthetic Record), a separate SMS marketing tool (Boulevard/SimpleTexting), a separate CRM (Symplast/PatientNow), and a separate pre/post-care document system. This tool consolidates 3-5 of those into one practice-specific intelligence layer that sits ON TOP of their existing scheduling system.

Best fit: practice owners who can articulate that their retention is leaking but can't pinpoint where. Less applicable to: brand-new med spas (under 100 patients, not enough data yet), and Botox-only injection clinics (use Service Reminder Engine instead, simpler is better).

The system manages every patient's active treatment timeline. For each patient, it tracks: which treatments they've had, which series they're in (e.g., "Sculptra series, 2 of 4 sessions complete"), when each session is due based on protocol cadences, when maintenance is needed, what contraindication windows are active (e.g., "no laser within 14 days of filler"), and what their projected 12-month revenue value is. Five distinct workflows fire from this data:

1. PRE-CARE SMS (24-48hr before any session): treatment-specific instructions ("avoid alcohol", "stop aspirin", "no sun exposure 7 days prior")
2. POST-CARE SMS (immediately after session): aftercare protocol with timeline ("ice 10 on/10 off for 2 hours", "sleep elevated tonight", "apply SPF 50 for 14 days")
3. SESSION DUE REMINDERS: when next session in an active series is approaching (different cadence per protocol)
4. CONTRAINDICATION ALERTS: when staff tries to book a treatment that conflicts with a recent treatment (e.g., scheduling HydraFacial 5 days after filler)
5. RESULTS MATURITY NOTIFICATIONS: when expected results should be visible (e.g., Sculptra mature at 6 months, automatic check-in: "How are you loving your results? Time for maintenance series?") The system ships with a curated Protocol Library containing 30+ pre-built treatment protocols (Botox, every major filler brand, Sculptra, microneedling, all laser treatments, HydraFacial, peels, body contouring, etc.) with their proper session counts, intervals, maturation timelines, and contraindication rules. Owner can edit any protocol or add custom ones.

This is one of the most complex builds in the library, clinical protocol management plus 5 SMS workflows plus contraindication enforcement. Expect Base44 to build in 25-35 minutes (longer than most). Likely follow-up prompts:

If the Protocol Library isn't pre-populated: "The PROTOCOL Library wasn't seeded with the 30+ treatments listed in the master prompt. Pre-populate every protocol with: treatment_name, category, session count/interval, result_maturity_days, maintenance_interval_days, full pre_care_instructions text, full post_care_instructions text, contraindication_rules JSON, and average pricing. Use the values specified in the original build prompt verbatim.

If you need to break this into a separate seeding function due to volume, that's fine, just make sure all 30+ are populated."

If contraindication checks aren't firing: "The contraindication check isn't running when staff books a new treatment. Add a backend function checkContraindications(patient_id, attempted_protocol_id, attempted_datetime) that: (1) fetches patient's TreatmentRecord history for past 30 days, (2) loads contraindication_rules from the attempted Protocol, (3) checks each rule against the patient's history, (4) returns array of any conflicts with specific dates and reasons. Fire this on the booking form's onSubmit and display warnings before allowing the booking to save."

If pre-care SMS aren't firing 24hr before: "Pre-care SMS workflow needs a scheduled function running every 30 minutes that queries TreatmentRecord WHERE status='scheduled' AND scheduled_datetime BETWEEN (now+settings.pre_care_send_hours_before-30min) AND (now+settings.pre_care_send_hours_before+30min) AND pre_care_sms_sent=false. For each match, generate the SMS using the Protocol's pre_care_instructions, send via Twilio, mark pre_care_sms_sent=true."

If post-care SMS aren't firing after appointments: "When a TreatmentRecord status changes to 'completed', trigger an immediate function sendPostCareSms(treatment_record_id) that loads the Protocol's post_care_instructions, personalizes with patient name and provider name via LLM, sends via Twilio, logs to SmsLog."

If the patient timeline visualization looks like a CRM list instead of a medical record: "The patient timeline view needs to be visually distinctive. Implement a vertical timeline component: each TreatmentRecord becomes a marker dot (color-coded by category) on a vertical line, with the treatment name + date + session # to the right. Future projected sessions should be lighter/translucent.

Active contraindication windows should be horizontal red bars spanning the dates they block. Use Mantine Timeline component or build custom with Tailwind."

If patient revenue forecasting looks wrong: "Projected_12_month_revenue calculation isn't working. For each patient, sum: (remaining sessions in active plans × average_session_price) + (any maintenance due in next 12 months × average_maintenance_price) + (typical Botox cycles per year × Botox price if patient has Botox history). This needs a backend function calculatePatientForecast that runs nightly for all active patients and stores the result on the Patient entity."

The biggest gotchas: (1) the Protocol Library MUST be substantial, empty library means no value. (2) Contraindication enforcement MUST work, wrong scheduling damages patient outcomes and creates liability. (3) HIPAA compliance must be verified before launch, get the BAAs signed.

This tool is the most clinically intricate in the library and the most defensible, competitors can't easily replicate the protocol depth.