BOOKING_DB — Admin

✅ Quick Popup: hanya perlukan Code Booking + Paste Booking Text (Date optional).
Total/Deposit/Balance/Payment Status akan auto extract dari text & auto update Sheet.

Ready

Code Booking (Column B) *

Timestamp (A)

Last Update (U)

Total (E)

—

Deposit (F)

—

Balance (P)

—

Payment Status (S)

—

Date Range (C)

Total (E)

Deposit (F)

Balance (P)

Customer Name (G)

Tel Customer (H)

Tel Backup (I)

Package Name (J)

Pax (K)

Border (L)

Hotel (M)

Trip Start (N)

Trip End (O)

Hotel Assigned (Q)

Driver Team (R)

Payment Status (S)

Paste Booking Text (D)

Remark (T)

Tip: Untuk elak “Failed to fetch”, pastikan WEB_APP_URL betul (link /exec) & deployment set ke Anyone.