Hướng dẫn tự động hóa lịch hẹn cho phòng khám tư nhân: Thoát khỏi thất thoát doanh thu vì bệnh nhân no-show

Appointment Automation Guide for Private Clinics: Stop Losing Revenue to Patient No-Shows

1. Chẩn đoán rủi ro cụ thể: phòng khám không mất tiền vì thiếu khách, mà vì khách đã đặt lịch nhưng không đến 8 giờ 15 sáng, bác sĩ...

1. Specific risk diagnosis: your clinic is not losing money because patients are missing, but because booked patients do not show up It is 8:15 in the morning. The doctor...

// Ví dụ cấu trúc dữ liệu lịch hẹn dùng để đồng bộ về dashboard
const appointment = {
  id: "APT-2025-00128",
  patientName: "Nguyen Van A",
  phone: "0900000000",
  service: "Nha khoa tong quat",
  appointmentTime: "2025-02-18T09:30:00+07:00",
  source: "Zalo",
  status: "new",
  owner: "Le tan co so 1",
  riskTags: ["khach_moi", "gio_cao_diem"],
  lastConfirmedAt: null
};

# Ví dụ Python đơn giản để chấm điểm nguy cơ no-show
from datetime import datetime, timedelta

def no_show_score(appt):
    score = 0
    if appt.get("status") == "new":
        score += 25
    if "khach_moi" in appt.get("riskTags", []):
        score += 20
    if "tung_bo_lich" in appt.get("riskTags", []):
        score += 35
    if appt.get("lastConfirmedAt") is None:
        score += 25
    if appt.get("serviceValue", 0) >= 2000000:
        score += 15
    hour = datetime.fromisoformat(appt["appointmentTime"]).hour
    if hour in [9, 10, 17, 18]:
        score += 10
    return min(score, 100)

def action_for_score(score):
    if score >= 70:
        return "Goi dien xac nhan truoc, neu khong nghe may thi gui Zalo va danh dau can lap slot du phong"
    if score >= 40:
        return "Gui nhac lich tu dong va yeu cau phan hoi xac nhan"
    return "Nhac lich tu dong thong thuong"

sample_score = no_show_score({
    "status": "new",
    "riskTags": ["khach_moi"],
    "lastConfirmedAt": None,
    "serviceValue": 3000000,
    "appointmentTime": "2025-02-18T09:30:00+07:00"
})
print(sample_score, action_for_score(sample_score))

// Checklist kỹ thuật khi triển khai automation lịch hẹn
const clinicAutomationChecklist = [
  "Dong bo lich hen tu Excel, phan mem phong kham, form web va kenh chat ve mot bang chung",
  "Chuan hoa trang thai lich hen: new, confirmed, need_call, arrived, cancelled, no_show",
  "Thiet lap rule nhac lich 24h, 3h, 60 phut truoc gio hen",
  "Gan diem rui ro no-show theo lich su, gia tri ca, khung gio, trang thai xac nhan",
  "Tao dashboard theo ngay cho quan ly: booked, arrived, cancelled, no_show, recovery_needed",
  "Phan quyen du lieu, khong de lich hen nam trong Zalo ca nhan cua mot nhan su",
  "Kiem tra log gui tin va log goi dien de truy vet khi co tranh cai"
];

// Example appointment data structure for syncing into a dashboard
const appointment = {
  id: "APT-2025-00128",
  patientName: "Nguyen Van A",
  phone: "0900000000",
  service: "General dentistry",
  appointmentTime: "2025-02-18T09:30:00+07:00",
  source: "Zalo",
  status: "new",
  owner: "Branch 1 receptionist",
  riskTags: ["new_patient", "peak_hour"],
  lastConfirmedAt: null
};

# Simple Python example for scoring no-show risk
from datetime import datetime

def no_show_score(appt):
    score = 0
    if appt.get("status") == "new":
        score += 25
    if "new_patient" in appt.get("riskTags", []):
        score += 20
    if "previous_no_show" in appt.get("riskTags", []):
        score += 35
    if appt.get("lastConfirmedAt") is None:
        score += 25
    if appt.get("serviceValue", 0) >= 2000000:
        score += 15
    hour = datetime.fromisoformat(appt["appointmentTime"]).hour
    if hour in [9, 10, 17, 18]:
        score += 10
    return min(score, 100)

def action_for_score(score):
    if score >= 70:
        return "Call first; if unanswered, send Zalo and mark as backup-slot risk"
    if score >= 40:
        return "Send automated reminder and request confirmation"
    return "Send standard automated reminder"

sample_score = no_show_score({
    "status": "new",
    "riskTags": ["new_patient"],
    "lastConfirmedAt": None,
    "serviceValue": 3000000,
    "appointmentTime": "2025-02-18T09:30:00+07:00"
})
print(sample_score, action_for_score(sample_score))

// Technical checklist for appointment automation deployment
const clinicAutomationChecklist = [
  "Sync appointments from Excel, clinic software, web forms, and chat channels into one shared board",
  "Standardize appointment statuses: new, confirmed, need_call, arrived, cancelled, no_show",
  "Set reminder rules for 24h, 3h, and 60 minutes before appointment time",
  "Score no-show risk based on history, case value, time slot, and confirmation status",
  "Create a daily dashboard for management: booked, arrived, cancelled, no_show, recovery_needed",
  "Set data permissions so appointments do not live only inside one staff member’s personal Zalo",
  "Track message logs and call logs for dispute handling and process review"
];