Hertz TWG Fleet Control
⏳ Checking cache…

Enter your PIN (6 digits)

TWG Fleet Booking System — authorised users only
?
—
—
—
👤 Profile
This name appears on bookings and in the header.
Email cannot be changed here. Contact an admin.
🔒 Change Password

👥 User Management

Loading users…
⚠ ✕
Location:
KAL60
BRF60
BRF62
RKL60
IPS60
BND60
SFP60
NER60
BRI50
COO50
Other A
Other B
Other C
Current Bookings: — 🇦🇺 Public Holiday 🏝️ QLD Holiday 🎓 School Holiday Click a cell to book  |  Click booked cell to edit/clear
🏛 Public Holiday
Pick-up
🕐 Pickup time
Return
🕐 Return time
Vehicle Booking #
📍
📋 Total Bookings —
🚌 Usable Vehicles —

✓ Available —
📊

Import Complete

Total Bookings Processed 0
0
✚ Added
0
↻ Updated
0
✕ Cancelled
🗑

Clear Bookings

Choose what to clear:
📅
Clear This Month
Remove all bookings for the current month
🗑
Clear All Months
Remove every booking in the system
Enter PIN to confirm
Enter your current PIN and choose a new 4-digit PIN.
🚨
Full Fleet Saturation Detected
All active vehicles are fully booked on the following dates

The following dates have 100% fleet utilisation — every active vehicle is booked. No further bookings can be accommodated on these days without adding vehicles or adjusting existing bookings.

DateDayActive FleetAll BookedBookings on Day
⚠ Operational Action Required

Review saturated days and consider: adding vehicles to the fleet or adjusting booking dates to free capacity at critical depots.

📊

Fleet Monitor

Live
Class Period
📈 Overview
📝 Summary
🚗 Availability
📋 Bookings
🚨 Alerts
🔐

Airtable Settings

Enter your PIN to access configuration

PIN-protected to prevent accidental changes

📄 Manual Update from Excel

Import bookings from a Cars+ reservation export — same columns as Airtable sync.

Expected columns: Cars+ Res No · Customer First/Last Name · RES Loc Out/In · RES Date Out/In · RES Time Out/In · Veh Class Reserved · RES Status · Res Days. Only rows with Status = O are imported. Unknown vehicle classes are skipped. Manual bookings are never overwritten unless they share the same Cars+ Res No.

📊 Import from Airtable

Connect to your Airtable base and import bookings directly.

🔗 Connection
airtable.com/appXXXXXXXXXX/tblXXXXXXXXXX/viw…
             ▲ Base ID                         ▲ Table ID (optional)
1. Open your Airtable base in a browser tab  →  2. Copy the full URL from the address bar  →  3. Paste it above
Checks your token → base → table step by step and shows exactly what's wrong
Create a table named Vehicles in the same base with text fields: Rego, Class, Location, Status, Notes + checkbox fields Temp, Deleted + text field Updated. Leave blank to keep vehicles local-only.
Create a table named Settings in the same base with a text field Key, a long-text field Value, and a text field Updated. This shares vehicle classes, PIN, field mappings and cancelled-booking records across all computers. Leave blank to keep configuration local-only.
Create a table named Users in the same base with fields Name (text), PIN (text), Role (text: admin/fleet) and Active (checkbox). Leave blank to use the single shared PIN.
🔄 Transfer this setup to another computer
Export your Airtable connection (base, tables, field mappings) as a code, then paste it on the other computer — no re-typing.
Click to list all tables in the base — then click a table name to select it.
📁 Field Mapping

Enter the exact Airtable field (column) name for each property. Fields marked * are required — leave others blank to skip.

First Name *
Last Name *
Booking Ref *
Rental Days
Pickup Date *
Return Date
Pickup Time
Return Time
Vehicle (Rego)
Vehicle Class *
Loc Out (Pickup)
Loc In (Return)
RES Status *
Extra Notes

💡 Status filter: only bookings with status O are imported. Vehicle Class reads Veh Class Reserved. Rental Days (Res Days) is stored as reference info. Leave "Vehicle" blank for auto-assignment.

📚 Class Alias Mapping

Map Airtable vehicle class values to system codes. Example: "12 Seater Bus" → M. Aliases are saved and applied automatically every time you load records.

Cars+ Ref Days Customer Class Pickup Return Loc Out Loc In Status Import
⚠
Fleet Capacity Exceeded — Bookings Could Not Be Assigned

The following bookings could not be allocated to any available vehicle. No vehicle was free for the requested date range:

Customer Name Pickup Date Return Date Dep. Time Ret. Time Ref# Location

⚠ These bookings will NOT be imported. Review vehicle availability, add vehicles, or adjust booking dates.

📋 Version Control

+ New Booking

⚠ Vehicle will be blocked for the entire rental period.
It will not appear as available for standard bookings and will be flagged as Long Term Rental in the fleet.
A specific vehicle must be selected — auto-assign is not allowed for LTR bookings.

🔍 Check Vehicle Availability

⚙ Manage Fleet Vehicles

Managing vehicles for:
Rego Location Group Status Remove

📅 Day Bookings

🔍 Esc
📍 Location: 🚌 Class: 📅 From: To:
Type to search across all bookings, vehicles and classes…
🚛
Fleet Operations
Loading…