Sheet tab is 'WorldPlay' not 'Booking Sheet'. Dates use DD/MM/YYYY
format. Room/bed columns are at indices 2/4 not 0/1. Room numbers
carry down for multi-bed rooms. Added 'Couch' to hh-living bed types.
Changed valueInputOption to RAW to prevent formula injection.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Sheet names with spaces need single-quoting in range strings,
otherwise 'Booking Sheet!A:J' fails to parse.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Users can now attend individual days at €10/day instead of full-week
only (€50). Partial-week attendees get Commons Hub accommodation at
per-night rates (€40 shared, €50 double). Villa restricted to
full-week. Booking sheet writes guest names only on selected days.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Convert single-step registration into a two-step flow:
- Step 1: Registration info → saves to JSON + Google Sheet with awaiting_payment status
- Step 2: Accommodation selection + price summary → creates Mollie checkout → redirects
On payment completion, Mollie webhook updates status, assigns bed on booking sheet,
sends confirmation email, and adds to Listmonk.
New files: api/booking-sheet.js, payment-success.html
New routes: /api/create-checkout-session, /api/mollie/webhook, /api/payment-status
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Jeff Emmett