Tutorials

Airport Transfer Booking Form and Dispatch Workflow

Plan an airport transfer inquiry, quote, confirmation, and dispatch workflow with required-field checks, local pickup time handling, role access, and synthetic examples.

Start building for free
5 min readPublished
Dispatcher reviewing pickup details before assigning a transfer
On this page

Build the transfer workflow as three distinct stages: collect a complete inquiry, send a quote, then record customer confirmation before dispatch. Store the pickup’s local date, local time, and time zone explicitly; a driver should receive an assigned trip only after the required fields are complete and the customer has accepted the quote.

This design responds to a recent operator question about capturing pickup and destination, travel date, passenger count, and contact details, then routing valid requests to a spreadsheet or CRM. The author was unsure how to handle missing fields before passing data downstream. The original question shows a request for that validation step.

Download the sample CSV · Download the form field specification

Capture the fields dispatch needs

Start with six tables:

  • trip_requests: customer ID, status, creation time, and update time.
  • pickup_details: pickup address, destination, local pickup date, local pickup time, time-zone identifier, and airport terminal when relevant.
  • passengers: passenger count, luggage count, contact name, email, and phone.
  • quotes: immutable quote version, request ID, pickup-details snapshot, amount, currency, expiry, and staff owner.
  • quote_acceptances: customer ID, accepted quote ID and version, and timestamp.
  • assignments: confirmed quote ID, driver ID, vehicle label, assignment time, and assignment status.

Keep quote and trip confirmation separate. A quote is the operator’s proposed price and conditions; it is not a confirmed trip. A customer confirmation records acceptance of a specific quote version. If the operator changes the price or pickup details, issue a new quote and ask the customer to accept that version before dispatch.

Mark required fields by route type. For every request, require pickup, destination, local date, local time, passenger count, and a contact method before generating a quote. For an airport pickup, require a terminal if it affects meeting instructions. Ask for a flight number only if the operator uses it; keep it as customer-provided reference text unless a flight-status integration is deliberately scoped and verified. Do not make the workflow depend on an assumed flight API.

When a field is missing, save the inquiry as needs_information, list the missing fields, and send the customer a direct follow-up form. Do not export it as dispatch-ready or notify a driver. Once all required details are present, move it to ready_to_quote for an operator to review.

Preserve the pickup’s local time

A pickup at 12:30 a.m. can fall on the day after a late-night booking was made. Store the date, time, and IANA time-zone name as separate values, such as 2026-11-08, 00:30, and America/New_York. Display all three in dispatch views. Do not derive the trip date from the browser’s current time zone or shift it silently during daylight-saving changes. Validate the local time against that zone: if the clock time occurs twice or does not occur during a daylight-saving transition, request an explicit offset or corrected time before quoting. Save the resolved UTC instant alongside the original local values.

Synthetic overnight row: a customer requests pickup at 11:50 p.m. on November 7, 2026, in America/New_York, from an airport terminal to a city address. A second trip at 12:30 a.m. on November 8 is a different local calendar date and should remain so in the form and dispatch list. These dates and trips are examples, not actual bookings.

Move from inquiry to dispatch

Dispatcher reviewing pickup details before assigning a transfer

AI-generated editorial concept; not a screenshot of a deployed app.

Use a small, explicit state model:

Current status Allowed next status Who can change it
needs_information ready_to_quote Customer completes fields; staff validates
ready_to_quote quoted Dispatch staff
quoted customer_confirmed, declined, expired Customer or system on expiry
customer_confirmed assigned Dispatch staff
assigned completed, cancelled Dispatch staff; assigned driver reports completion

Validate the transition on the server, and record who acted, which quote version was accepted, and when. A system should never assign a driver directly from needs_information, ready_to_quote, or quoted.

Customers can create a request, add missing information, and read their own trip. Dispatch staff can manage the operator’s requests, quotes, and assignments. A driver should read only the trips assigned to that driver, with only the contact and pickup details needed to perform the trip. Keep internal quote notes, other customers’ details, and unassigned trips out of driver views. If using Supabase, configure and check row-level policies for each table and operation; connecting a backend alone does not implement those rules. Atoms’ Supabase guide

After a request changes state, send the relevant event to the team’s notification or spreadsheet workflow. Connector actions and permissions depend on the connector and account, so verify the exact available write action before designing around it. Atoms’ integrations guide

Optional deposit after confirmation

Collecting an inquiry does not require payment. If the operator needs a deposit, offer payment after the customer confirms a quote. Keep the charge tied to the confirmed request and process the payment result on the server. With Stripe Checkout, a success-page redirect alone cannot guarantee fulfillment; Stripe’s guide calls for server-side webhook fulfillment that safely handles the same Checkout Session more than once. Store a unique session key and processed state before changing the trip’s payment status. Stripe’s Checkout fulfillment guide

Form template and acceptance checks

The accompanying form-template.json lists the customer fields, conditional airport fields, quote acceptance, and confirmation message. The sample.csv contains synthetic requests: one missing an airport terminal, one complete request awaiting a quote, and one overnight pickup. Use these to check:

  1. An airport inquiry missing its required terminal enters needs_information; no quote or driver assignment is created.
  2. Completing required fields moves the request to operator review, but does not imply the customer has accepted a price.
  3. Accepting a quote records the exact quote version; only then can dispatch assign a driver.
  4. The November 7 late-night pickup and November 8 after-midnight pickup retain their respective local dates and America/New_York zone after refresh.
  5. Customer A cannot open customer B’s request. An unassigned driver cannot read or claim the trip; an assigned driver sees only that trip.
  6. If deposits are enabled, submitting the same successful payment event twice results in one payment-state change.

The Atoms Supabase guide recommends using harmless sample data, refreshing the app, and checking the matching saved row as part of verifying persistence. Atoms’ save-data verification steps

Build prompt

Use this prompt to create the first version in Atoms:

text
Build an airport transfer inquiry, confirmation, and dispatch app.
Use Atoms Cloud or Supabase for this project, not both.
Create trip_requests with customer_id, status, created_at, and updated_at.
Create pickup_details with request_id, pickup_address, destination, local_pickup_date, local_pickup_time, timezone, and terminal.
Create passengers with request_id, passenger_count, luggage_count, name, email, and phone.
Create immutable quotes with request_id, version, pickup_snapshot, amount_cents, currency, expires_at, and quoted_by.
Create quote_acceptances with customer_id, quote_id, version, and accepted_at.
Changed price or pickup details require a new quote and acceptance.
Create assignments with request_id, driver_id, vehicle_label, assigned_at, and assignment_status.
Keep quote and confirmed trip as distinct states and records.
Require pickup, destination, local date, local time, timezone, passenger count, and contact before quoting.
Require terminal for airport pickup and flight number only when the operator needs it.
Show missing required fields and save the request as needs_information.
Allow needs_information -> ready_to_quote -> quoted -> customer_confirmed -> assigned -> completed.
Allow quoted -> declined or expired; allow assigned -> cancelled with a reason.
Reject every other transition on the server.
Show the timezone beside every pickup date and time; never infer it from the viewer device.
Store the local pickup date, time, and IANA timezone separately.
Reject ambiguous or nonexistent local times until the customer clarifies.
Persist the resolved UTC instant without replacing the original local values.
Handle overnight trips without changing the selected calendar date silently.
Let customers read only their own requests and submit missing details for their request.
Let dispatch staff manage all requests for this operator.
Let a driver read only trips assigned to that driver, with minimum passenger contact details.
Keep internal quote notes, customer phone, and driver notes private to authorized roles.
Seed fictional requests including a missing terminal and an overnight pickup.
Do not call any flight-status API; treat flight number as customer-provided reference text.
Add checks for missing fields, quote acceptance, timezone display, and overnight pickup.
Check refresh persistence and that one customer's request is hidden from another.
Check an unassigned driver cannot read or claim a trip.
Check only a complete, customer-confirmed request can be assigned to a driver.

Copy the build brief and use it to create your version in Atoms.

Build a transfer workflow

The workflow can start with manual dispatch and customer-entered flight references. Add an external API only when its provider, permissions, failure handling, and actual behavior have been verified for the operator’s account.

Share this article
Made with Atoms

Your next idea starts here.

Turn what you learned into a working app or website.

Start building for free