Jones Operations is deployed
The cloud application is online. Next, configure the Supabase project URL and public publishable key in Cloudflare Worker settings.
No bookings can be created from this starter yet. We are connecting the existing V24 workflows in stages.
Do not paste your Supabase database password or service-role/secret key into website settings.
Administrator sign in
Use the Supabase account you created and approved in the admin_users table.
Jones Operations
Filter bookings
Status: 4 active
Autoforms
Manage operational messages and formsAutomated Supplier Emails
Supplier assignment confirmations are queued after booking updates. The 06:00 and 17:00 UK schedules send one grouped delivery email and one grouped collection email per supplier when there are matching jobs.
Recent email history
An email marked SENT means Resend accepted it, not necessarily that the supplier received it. Check delivery/bounces in Resend. Automation starts OFF; do not enable with active test bookings pointing to real third-party addresses.
Edits are saved in Supabase and used for future outgoing messages. Previously queued or sent messages will not be rewritten. Emails are sent as plain text.
Email types — switch individual messages on or off
A disabled type will not be generated or sent by the current email automation. Previously sent emails cannot be recalled. The main automatic-sending switch remains independent.
Supported placeholders
{{order}}, {{supplier_contact}}, {{delivery}}, {{collection}}, {{site}}, {{postcode}}, {{qty}}, {{pod_link}}, {{poc_link}}, {{links}}, {{jobs}}, {{job_count}}. Sample preview never creates real links or sends emails.
Preview (sample values only)
Change the instructions shown to suppliers. Core photo, quantity, signature, allocation and scheduled-date requirements remain mandatory and cannot be disabled here.
Forms are available only on their scheduled UK date to an allocated supplier with a valid link. Existing signed proofs and PDFs remain unchanged.
The Issues screen checks for overdue POD/POC records when opened. Missing/damaged quantities and failed email events are always recorded for financial accuracy.
These preferences control future overdue issue creation, not deletion of historical issues. This stage does not send extra alert emails or WhatsApp notifications.
Backups and recovery
Status: production backup and restore verification not completed.
Supabase and Cloudflare host your records, but that is not a substitute for a verified, independent database and private-file backup. The Stage 8+9 package includes encrypted backup scripts and a restore runbook. These only protect data once you actually run, schedule, store off-site, and successfully restore-test them. No automatic backups are enabled merely by installing the website.
Do not treat a GitHub code commit or an SQL Editor query history as a backup of customer bookings or signed PDFs.
WhatsApp — future integration
Not active. We will consider opt-in WhatsApp Business notifications after email automation, permissions, and consent requirements are tested. No messages are sent here.
Invoicing — QuickBooks remains separate
When the POC is completed, review the breakdown here. Enter one positive/negative adjustment if needed, the QuickBooks invoice number, and optionally notes. One confirmation closes the invoice; Jones Operations does not create or send QuickBooks invoices.
Issues requiring attention
Missing or damaged cones require a manual review, not automatic replacement charges. Failed supplier emails and overdue forms may also appear here.
Administrator accounts
All active administrators have equal access. Invitations use Supabase Authentication; credentials are never displayed or stored here. Deactivation blocks database access immediately.
Invite an administrator
Supabase must be configured to deliver invitation emails. If invitation mail is unavailable, create a user through Supabase Authentication first; see the included Admin Setup guide.
Booking charges and supplier costs
One CSV row per booking with what the customer is charged and what is agreed payable to suppliers (ex VAT). Supplier costs are not proof of payment. Final invoice and payment reporting stays in QuickBooks. Exports paginate through all stored bookings (up to 30,000 per run).
Monthly customer charges vs supplier transport costs
Ex VAT, grouped by booking delivery month; estimates for bookings not yet invoiced.