Hertz TWG Fleet Control
⏳ Checking cache…

Enter your PIN (6–8 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…