Skip to main content

Fleet Manager Dashboard

Source: Fleet_Manager_Dashboard_1_0 (logistics-app) Page URL: https://creatorapp.zoho.com.au/clientportal/logistics-app/#Page:Fleet_Manager_DashbPage input params: Delivery_Date (string), currentOnHire, deliveriesToday, freeDeliveries, freeReturns, previousOnHires, returnsToday (int, set by the page-load script below), tab (int, drives the bottom tab strip). As of the latest revision, deliveriesToday, freeDeliveries, freeReturns, previousOnHires, and returnsToday are all dead code alongside currentOnHire — see the note in Page Load Logic below.

Page Load Logic​

  • previousOnHires ← Fleet_utilisation[Date_field == zoho.currentdate.addDay(-1) && Vehicle_Type == "All"].On_Hire — yesterday's "All vehicle types" utilisation snapshot.
  • deliveriesToday ← count of Add_Job where Delivery_Date in today and (Hire_Status1 == "On Hire" or Hire_Status1 == "Off Hire"). (was Delivery_Date == zoho.currentdate in a prior revision — same effect, operator form changed.)
  • returnsToday ← count of Add_Job where Hire_Status1 == "Off Hire" and Return_Date_Date_Only == zoho.currentdate.
  • freeDeliveries ← count of Free_Hire where On_Hired_Since_Date_and_Time == zoho.currentdate.
  • freeReturns ← count of Free_Hire where Off_Hire_Date_and_Time in today.
  • currentOnHire — dead code. The assignment (Add_Car[Vehicle_Status == "On Hire" || "Free Hire" || "IITR On Hire"].count()) is commented out in the script, so this input param is never actually set by page load.

All five of previousOnHires, deliveriesToday, returnsToday, freeDeliveries, and freeReturns are now also dead code, joining currentOnHire. Panels 14–18 below (Previous Days On Hire, On Hired Today, Off Hired Today, Count of Free Deliveries, Count of Free Returns) used to display these ${var} page variables directly; they've since been converted to live criteria-driven tiles (Form Data type bound to a form's .ID.count, same as every other panel on this page) that no longer read the page-load values. The script above still runs and still assigns input.* on every page load — it's just that nothing on the page consumes the result anymore.

Full-width search box at the top of the page. Results open Master_Fleet_List in a new window.

  • Placeholder: "Search Rego or Make or Model or VIN"
  • Criteria: Registration == input.searchString || Make == input.searchString || Model == input.searchString || VIN == input.searchString

Action Buttons​

Button textActionTarget
Generate Fleet UtilizationExecuteFunction → utilisation.daily_Utilisation—
Vehicle Purchase RequestOpenPage → Vehicle_Purchase_Dashbaordsame-window

Shared Base Criteria​

Several groups of tiles below repeat the same underlying condition. Defined once here and referenced as "Base Criteria" per group.

Active Fleet Base — used by most Fleet_Report-driven tiles (fleet-type counts, Vehicle Status tiles, Location tiles):

Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease" || Finance_Type is null

Location Status Exclusion — used by all Location tiles, on top of Active Fleet Base. Passed to the report as Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19 (previously Vehicle_Status_op=27; the tile-side exclusion clause itself is unchanged, only the report query op code moved):

Vehicle_Status != "On Hire" && Vehicle_Status != "Free Hire" && Vehicle_Status != "Sold" && Vehicle_Status != "Grounded" && Vehicle_Status != "IITR On Hire"

Rego Expiry Base — used by all Rego Expiry tiles:

Vehicle_Active == "Yes" && Finance_Type != "External Hire" && Finance_Type != "Short Term Lease" && Vehicle_Status != "Sold" && Vehicle_Status != "Grounded"

A handful of tiles below wrap the first clause of Active Fleet Base in parentheses in the source — (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null — which changes operator precedence against whatever trailing clause follows. This now includes Total Fleet, Cars, Bikes, Tow Trucks, Vehicles - On Hires, and Active Free Hires (each paired with its own trailing && clause — Vehicle_Status != "Sold" for the first four, Vehicle_Status == "On Hire" for Vehicles - On Hires, Vehicle_Status == "Free Hire" for Active Free Hires), in addition to Reserved / In For Service / Marketing Use. Called out inline where it happens. Cars, Bikes, and Tow Trucks previously deviated from Active Fleet Base entirely (swapping in Finance_Type != "Cross Hire", and Tow Trucks additionally lacked the Finance_Type is null fallback) — that's no longer the case; all three now use this parenthesised Active Fleet Base form.

Report-level base filter — Rental_Rates_Report: this report has its own saved filter, configured directly in Zoho Creator's report builder (Filter tab) rather than passed by any tile:

Movement_Type != "Repair Only"

Every tile that opens Rental_Rates_Report (panels 11, 15, 16 below) is filtered by this in addition to whatever parameters that tile passes — it isn't visible in the page's Content markup at all, only in the report's own config. Panel 11 (Vehicles On Hire - Recoverable) now also carries an explicit Movement_Type != "Repair Only" clause directly in its own tile criteria, redundant with this report-level filter. Panel 12 (Vehicles On Hire - Not Recoverable) used to open Rental_Rates_Report as well but no longer does — see its entry below.

Panel Criteria (detail)​

1. Total Fleet​

  • Form: Add_Car
  • Display: Count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status != "Sold" — Active Fleet Base (parenthesised) plus a new Vehicle_Status != "Sold" exclusion
  • Query passing to report: Vehicle_Status=Sold&Vehicle_Status_op=19 ("not equal" — excludes Sold, matching the tile's own criteria)
  • Action: OpenReport (new-window) — previously OpenPage (same-window) to Master_Fleet_Report_1_0
  • Report: Fleet_Report — previously opened the page Master_Fleet_Report_1_0 directly
  • Report filter: same as "Query passing to report" above

2. Active Vehicles (new)​

  • Form: Add_Car
  • Display: Count — thisapp.Add_Car.ID.count
  • Criteria:
    • Vehicle_Active == "Yes"
    • Vehicle_Status != "Sold"
    • Vehicle_Status != "Grounded"
    • Vehicle_Status != "In Repairs"
    • Vehicle_Status != "In For Service"
    • Finance_Type != "External Hire"
    • Finance_Type is not null — note the polarity: this tile requires financing to be set, the opposite of Active Fleet Base's || Finance_Type is null fallback
    • (does not use Active Fleet Base — its own bespoke set of exclusions)
  • Action: OpenReport (new-window)
  • Report: Vehicle_Active_1_0
  • Report filter: (no parameters passed — opens Vehicle_Active_1_0 at its own default/saved view)
  • Note: newly inserted between Total Fleet and Cars, shifting every panel number below by one relative to prior revisions of this doc.

3. Cars​

  • Form: Add_Car
  • Display: Count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status != "Sold" && Vehicle_Type == "Car" — Active Fleet Base (parenthesised) plus Vehicle_Status != "Sold" and Vehicle_Type == "Car"
    • previously swapped the base's Finance_Type != "Short Term Lease" for Finance_Type != "Cross Hire", and had no Vehicle_Status exclusion — no longer the case
  • Query passing to report:
    • Vehicle_Type=Car&Vehicle_Status=Sold&Vehicle_Status_op=19
  • Report: Fleet_Report
  • Report filter: same as "Query passing to report" above

4. Bikes​

  • Form: Add_Car
  • Display: Count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status != "Sold" && Vehicle_Type == "Bike" — same pattern as Cars
    • previously swapped in Finance_Type != "Cross Hire" with no Vehicle_Status exclusion — no longer the case
  • Query passing to report:
    • Vehicle_Type=Bike&Vehicle_Status=Sold&Vehicle_Status_op=19
  • Report: Fleet_Report
  • Report filter: same as "Query passing to report" above

5. Tow Trucks​

  • Form: Add_Car
  • Display: Count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status != "Sold" && Vehicle_Type == "Tow Truck" — same pattern as Cars/Bikes
    • previously used Finance_Type != "Cross Hire" with no Finance_Type is null fallback (the doc used to call this out as the one exception among Cars/Bikes/Tow Trucks) — it now has the fallback like every other tile in this group
  • Query passing to report:
    • Vehicle_Type=Tow Truck&Vehicle_Status=Sold&Vehicle_Status_op=19
  • Report: Fleet_Report
  • Report filter: same as "Query passing to report" above

6. Truck, Boat & Trailers​

  • Form: Add_Car
  • Display: Count
  • Criteria:
    • Vehicle_Type == "Truck" || "Boat" || "Trailer"
    • Vehicle_Active == "Yes"
    • Vehicle_Status != "Sold" — replaces the previous Finance_Type != "Cross Hire" clause, which has been dropped
  • Report: truck_boat_trailers
  • Report filter: (no parameters passed — opens truck_boat_trailers at its own default/saved view, not filtered to this tile's count)

7. Vehicle Finance Report – Fleet Manager​

  • Form: Add_Car
  • Display: Count
  • Criteria:
    • Vehicle_Active == "Yes"
    • Vehicle_Status != "Sold"
    • Finance_Type != "External Hire"
    • Finance_Type != "Short Term Lease"
  • Report: Vehicle_Finance_Report_Fleet_Manager
  • Report filter: (no parameters passed — opens Vehicle_Finance_Report_Fleet_Manager at its own default/saved view, not filtered to this tile's count)

8. Vehicles to Be Financed 1.0​

  • Form: Add_Car
  • Display: Count
  • Criteria:
    • Available_Finance == true
    • Vehicle_Active == "Yes"
    • Vehicle_Status != "Sold"
    • Finance_Type != "Short Term Lease"
    • Finance_Type != "External Hire"
  • Report: Vehicles_to_Be_Financed_1_01
  • Report filter: (no parameters passed — opens Vehicles_to_Be_Financed_1_01 at its own default/saved view, not filtered to this tile's count)

9. Vehicle Movement​

  • Form: Vehicle_Movement
  • Display: Count
  • Criteria: (no filter — direct record count)
  • Report: All_Vehicle_Movements
  • Report filter: (no parameters passed — opens All_Vehicle_Movements at its own default/saved view)

10. Vehicles - On Hires​

  • Form: Add_Car
  • Display: Count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status == "On Hire" — Active Fleet Base (parenthesised) plus Vehicle_Status == "On Hire"
    • previously Vehicle_Status == "On Hire" || Vehicle_Status == "IITR On Hire" with Vehicle_Active == "Yes" — the IITR On Hire alternative has been dropped, and the finance exclusion added
  • Action: OpenPage (same-window)
  • Page: Vehicles_on_Hire_1_0

11. Vehicles On Hire - Recoverable​

  • Form: Add_Job
  • Display: Count
  • Criteria:
    • Hire_Status1 == "On Hire"
    • Rental.Rental_Recovery_type == "3rd Party" || "Direct" || "CBR - Not At Fault" || "CBR - Not At Fault Direct" || "CBR - At Fault" — "CBR - At Fault" now sourced from Rental.Rental_Recovery_type, previously Claim_Form_2.Rental_Recovery_type
    • Movement_Type != "Repair Only" — new explicit clause, redundant with the report's own saved filter (see Shared Base Criteria)
  • Query passing to report:
    • Hire_Status1=On Hire&Rental.Rental_Recovery_type=[3rd Party,Direct,CBR - Not At Fault,CBR - Not At Fault Direct,CBR - At Fault]
    • previously Hire_Status=On Hire&&Rental_Recovery_Type=3rd Party||... (flat OR'd Rental_Recovery_Type params, field name Hire_Status not Hire_Status1, and CBR - At Fault was not included in the query at all) — now uses the bracket-list syntax seen elsewhere in this doc
  • Report: Rental_Rates_Report
  • Report base filter (saved on the report): Movement_Type != "Repair Only"
  • Report filter: same as "Query passing to report" above, on top of the report base filter
  • Note: the tile's <text> element itself carries a redundant, identical action = OpenReport pointing at the same report — removed. The duplicate action/componentLinkName/target on the <text> element is gone in this revision; only the outer <pc> container carries the click action now.

12. Vehicles On Hire - Not Recoverable​

  • Form: Add_Job
  • Display: Count — thisapp.Add_Job.ID.count
  • Criteria:
    • Recovery_Type != "Recto Hire"
    • Hire_Status1 == "On Hire"
    • Movement_Type != "Repair Only"
    • Rental.Rental_Recovery_type == "CBR - At Fault" || "Private Job" || "CBR No Hire On Policy" || "Free Loan Car"
    • previously Claim_Form_2.Rental_Recovery_type for "CBR - At Fault" / "Private Job" / "CBR No Hire On Policy" and Rental.Rental_Recovery_type only for "Free Loan Car" — all four are now sourced from Rental.Rental_Recovery_type
    • Movement_Type != "Repair Only" appears a second time in the raw criteria string (redundant with the instance above)
  • Action: OpenReport (new-window)
  • Report: Vehicles_On_Hire_Not_Recoverable — new dedicated report; previously opened Rental_Rates_Report
  • Report filter: (no parameters passed — the parameters attribute that used to pass Hire_Status=On Hire&&Rental_Recovery_Type=...&&Recovery_Type=Recto Hire to Rental_Rates_Report has been removed entirely; the new dedicated report is presumably pre-scoped)
  • Note: because this no longer opens Rental_Rates_Report, the Movement_Type != "Repair Only" report-level base filter documented under Shared Base Criteria does not apply here — hence the criteria now carries that exclusion explicitly, twice.

13. Active Free Hires​

  • Form: Add_Car
  • Display: Count — thisapp.Add_Car.ID.count
  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null && Vehicle_Status == "Free Hire" — Active Fleet Base (parenthesised) plus Vehicle_Status == "Free Hire"
    • this tile has been revised twice: it originally ran on Add_Car directly (Vehicle_Status == "Free Hire" && Vehicle_Active == "Yes"), then briefly moved to a Free_Hire*-form/Fleet_Id lookup approach, and has now settled back onto Add_Car using the same parenthesised Active Fleet Base pattern as Total Fleet/Cars/Bikes/Tow Trucks/Vehicles - On Hires
  • Query passing to report: Vehicle_Status=Free Hire
  • Action: OpenReport (new-window)
  • Report: Fleet_Report — previously opened Active_Free_Hire_Reports
  • Report filter: same as "Query passing to report" above
  • Note: this criteria/report/params combination is now functionally identical to panel 23 ("Free Hire" under Vehicle Status Tiles), modulo the parenthesisation difference in how Active Fleet Base is written — the dashboard effectively has two tiles for the same count.

14. Previous Days On Hire​

  • Form: Fleet_utilisation
  • Display: Count — thisapp.Fleet_utilisation.ID.count — previously a static ${previousOnHires} page variable computed once at page load
  • Criteria:
    • Date_field == zoho.currentdate.addDay(-1)
    • Vehicle_Type == "All"
    • (same logical condition as before — it's now expressed as a live tile criteria instead of being pre-computed by the page-load script; see the Page Load Logic dead-code note above)
  • Action: (none — still a static display, not clickable)

15. On Hired Today​

  • Form: Add_Job
  • Display: Count — thisapp.Add_Job.ID.count — previously a static ${deliveriesToday} page variable
  • Criteria:
    • Delivery_Date_Time is today — field renamed from Delivery_Date, operator changed from == zoho.currentdate
    • Movement_Type != "Repair Only" — new explicit clause
    • Hire_Status1 == "On Hire" || "Off Hire"
  • Query passing to report:
    • Delivery_Date_Time_op=32
    • Hire_Status1=[On Hire,Off Hire] — previously Hire_Status1=[On Hire] only; now matches both statuses like the criteria does
  • Report: Rental_Rates_Report
  • Report base filter (saved on the report): Movement_Type != "Repair Only"
  • Report filter: same as "Query passing to report" above, on top of the report base filter

16. Off Hired Today​

  • Form: Add_Job
  • Display: Count — thisapp.Add_Job.ID.count — previously a static ${returnsToday} page variable
  • Criteria:
    • Return_Date_Date_Only is today — operator changed from == zoho.currentdate
    • Movement_Type != "Repair Only" — new explicit clause
    • Hire_Status1 == "Off Hire"
  • Query passing to report:
    • Return_Date_op=32
    • Hire_Status1=[Off Hire]
  • Report: Rental_Rates_Report
  • Report base filter (saved on the report): Movement_Type != "Repair Only"
  • Report filter: same as "Query passing to report" above, on top of the report base filter

17. Count of Free Deliveries​

  • Form: Free_Hire
  • Display: Count — thisapp.Free_Hire.ID.count — previously a static ${freeDeliveries} page variable
  • Criteria:
    • On_Hired_Since_Date_and_Time is today — operator changed from == zoho.currentdate
    • Fleet_Id.Vehicle_Status == "Free Hire" — new clause, not present in the prior page-load computation
  • Query passing to report:
    • On_Hired_Since_Date_and_Time_op=32
  • Report: Active_Free_Hire_Reports
  • Report filter: same as "Query passing to report" above

18. Count of Free Returns​

  • Form: Free_Hire
  • Display: Count — thisapp.Free_Hire.ID.count — previously a static ${freeReturns} page variable
  • Criteria:
    • Fleet_Id.Vehicle_Status == "Free Hire" — new clause
    • Off_Hire_Date_and_Time is today — previously Off_Hire_Date_and_Time in today, same effect
  • Action: OpenReport (new-window)
  • Report: Today_Free_Return_Reports — new dedicated report; previously opened Active_Free_Hire_Reports
  • Report filter: (no parameters passed — the parameters attribute that used to pass Off_Hire_Date_and_Time_op=32 to Active_Free_Hire_Reports has been removed; the new dedicated report is presumably pre-scoped)

19. Current On Hire + Free Hire​

  • Form: Add_Car
  • Display: Count
  • Criteria: Active Fleet Base, plus:
    • Vehicle_Status == "On Hire" || "Free Hire"
  • Query passing to report:
    • Vehicle_Status=[On Hire,Free Hire]
  • Report: Fleet_Report1
  • Report filter: same as "Query passing to report" above

Vehicle Status Tiles​

Panels 20–34 all open Add_Car, display thisapp.Add_Car.ID.count, and share Active Fleet Base, plus Vehicle_Status == "<value>". All open Fleet_Report unless noted, with the report filter Vehicle_Status=<value> (same value as the criteria). (No content changes in this revision — only renumbered to make room for panel 2, Active Vehicles.)

20. Available​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Available"
  • Query passing to report: Vehicle_Status=Available
  • Report filter: same as "Query passing to report" above

21. On Hire​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "On Hire"
  • Query passing to report: Vehicle_Status=On Hire
  • Report filter: same as "Query passing to report" above

22. IITR On Hire​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "IITR On Hire"
  • Query passing to report: Vehicle_Status=IITR On Hire
  • Report filter: same as "Query passing to report" above

23. Free Hire​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Free Hire"
  • Query passing to report: Vehicle_Status=Free Hire
  • Report filter: same as "Query passing to report" above

24. Reserved​

  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null, plus Vehicle_Status == "Reserved" — (base clause parenthesised on this tile — see Shared Base Criteria note)
  • Query passing to report: Vehicle_Status=Reserved
  • Report filter: same as "Query passing to report" above

25. In Repairs​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "In Repairs"
  • Query passing to report: Vehicle_Status=In Repairs
  • Report filter: same as "Query passing to report" above

26. In For Service​

  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null, plus Vehicle_Status == "In For Service" — (base clause parenthesised on this tile)
  • Query passing to report: Vehicle_Status=In For Service
  • Report filter: same as "Query passing to report" above

27. Grounded​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Grounded"
  • Query passing to report: Vehicle_Status=Grounded
  • Report filter: same as "Query passing to report" above

28. At Cleaning Service​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "At Cleaning Service"
  • Query passing to report: Vehicle_Status=At Cleaning Service
  • Report filter: same as "Query passing to report" above

29. Marketing Use​

  • Criteria: (Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease") || Finance_Type is null, plus Vehicle_Status == "Marketing Use" — (base clause parenthesised on this tile)
  • Query passing to report: Vehicle_Status=Marketing Use (trailing space present in the source parameters value)
  • Report filter: same as "Query passing to report" above

30. Pending​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Pending"
  • Query passing to report: Vehicle_Status=Pending
  • Report filter: same as "Query passing to report" above

31. Sold​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Sold"
  • Query passing to report: Vehicle_Status=Sold
  • Report filter: same as "Query passing to report" above

32. Detailing​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "Detailing"
  • Query passing to report: Vehicle_Status=Detailing
  • Report filter: same as "Query passing to report" above

33. N/A​

  • Criteria: Active Fleet Base, plus Vehicle_Status == "N/A"
  • Query passing to report: Vehicle_Status=N/A
  • Report filter: same as "Query passing to report" above

34. Cross Hires​

  • Criteria: Vehicle_Active == "Yes" && Finance_Type == "Cross Hire" && Vehicle_Status == "On Hire" — (does not use Active Fleet Base; note it requires Cross Hire finance, unlike every other status tile which excludes it)
  • Report: External_Hires (not Fleet_Report)
  • Report filter: (no parameters passed)

Service Due Tiles​

Panels 35–37 each open a dedicated report (not Fleet_Report), no parameters passed — the report itself is scoped to the KM threshold. (No content changes in this revision — only renumbered.)

35. Service Due < 500 KM's​

  • Form: Add_Car
  • Display: Count — thisapp.Add_Car.ID.count
  • Criteria: Active Fleet Base, plus KM_s_Until_Next_Service < 500
  • Report: Service_Due_Less_than_500_KM_s_Report
  • Report filter: (no parameters passed)

36. Service Due < 1000 KM's​

  • Form: Add_Car
  • Display: Count — thisapp.Add_Car.ID.count
  • Criteria: Active Fleet Base, plus KM_s_Until_Next_Service < 1000
  • Report: Service_Due_Less_than_1000_KM_s_Report
  • Report filter: (no parameters passed)

37. Service Due < 2000 KM's​

  • Form: Add_Car
  • Display: Count — thisapp.Add_Car.ID.count
  • Criteria: Vehicle_Active == "Yes" && Finance_Type != "Cross Hire" || Finance_Type is null, plus KM_s_Until_Next_Service < 2000 — (uses Finance_Type != "Cross Hire" instead of "Short Term Lease", inconsistent with the other two Service Due tiles, kept as-is from the source)
  • Report: Service_Due_Less_than_2000_KM_s_Report
  • Report filter: (no parameters passed)

Rego Expiry Tiles​

Panels 38–41 share Rego Expiry Base, plus a date condition each. Each opens a dedicated report, no parameters passed. (No content changes in this revision — only renumbered.)

38. Expires Within 7 Days​

  • Criteria: Rego Expiry Base, plus Registration_Due_Date in next 7 days
  • Report: Expires_Within_7_Days
  • Report filter: (no parameters passed)

39. Expires Within 14 Days​

  • Criteria: Rego Expiry Base, plus Registration_Due_Date in next 14 days
  • Report: Expires_Within_14_Days
  • Report filter: (no parameters passed)

40. Expires Within 30 Days​

  • Criteria: Rego Expiry Base, plus Registration_Due_Date in next 30 days
  • Report: Expires_Within_30_Days
  • Report filter: (no parameters passed)

41. Rego Expired​

  • Criteria: Rego Expiry Base, plus:
    • Registration_Due_Date < zoho.currentdate.addday(0)
    • Registration_Due_Date < zoho.currentdate.addday(30)
  • Report: Rego_Expiry_Report
  • Report filter: (no parameters passed)

Location Tiles​

Panels 42–64 all open Fleet_Report and count Add_Car.ID.count. Panels 42–63 share Active Fleet Base + Location Status Exclusion unless noted, plus a location-specific condition.

The Fleet Vehicle Location Refactor has progressed much further since this doc was last written up: every tile below is now off the old split Vehicle_Location_Type.Place_Name / Vehicle_Sub_location.Sub_Location_Name fields and onto the merged Rental_Vehicle_Location field. What's left is an exact-match-vs-fuzzy-match inconsistency:

  • Repair Shop, Crash Claim HQ, George St Carpark, Newcastle, Park Road, John St, Powell St, Decal, Parked on Street, Other, Internal/Mechanical, Cleaning Service, Tyres, and Quality Yard now use Rental_Vehicle_Location.contains("..."), often against a shortened match string (dropping the "Crash Claim HQ-" prefix, e.g. John St went from an exact match on "Crash Claim HQ-John Street" to .contains("John St")). Repair Shop, Crash Claim HQ, Decal, Other, Internal/Mechanical, Cleaning Service, and Tyres additionally wrap the Active Fleet Base clause in parentheses (same precedence-changing pattern noted under Shared Base Criteria); the rest of this .contains() group do not.
  • Mark St, Crane St, Hillcrest, Basement, Recto Section, Backwall, CC HQ Wash, and Assessment Lane still do an exact == match against the full "Crash Claim HQ-<name>" string — their tile criteria wasn't touched. Curiously, seven of these eight (all but Mark St, which uses a bracket-list OR) had their report parameters updated to add Rental_Vehicle_Location_op=26 ("contains") anyway, so the report link now claims a fuzzy-match op the tile's own criteria doesn't perform. Worth a source cleanup, but it doesn't affect what the tile counts — only how its "view report" link is scoped.

42. Repair Shop​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Repair Shop") — base clause parenthesised on this tile
  • Query passing to report: Rental_Vehicle_Location=Repair Shop&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Note: the report parameter has a typo — Re0pair Shop (stray "0") instead of Repair Shop. The tile's own criteria spells it correctly, so the displayed count is unaffected, but the "view report" link will filter on the misspelled value and likely return no/wrong rows.
  • Report filter: same as "Query passing to report" above

43. Crash Claim HQ​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Crash Claim HQ") — base clause parenthesised on this tile
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

44. George St Carpark​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("George Street Carpark")
  • Query passing to report: Rental_Vehicle_Location=George Street Carpark&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

45. Newcastle​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Newcastle Base") — previously two conditions (Vehicle_Location_Type.Place_Name == "Crash Claim HQ" AND Vehicle_Sub_location.Sub_Location_Name == "Newcastle Base"); now a single merged-field condition
  • Query passing to report: Rental_Vehicle_Location=Newcastle Base&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

46. Park Road​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Park Road") — previously a two-part condition (Crash Claim HQ + "Park Road Carpark"); now single, and the match string dropped "Carpark"
  • Query passing to report: Rental_Vehicle_Location=Park Road&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

47. John St​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("John St") — previously an exact match on "Crash Claim HQ-John Street"; now fuzzy-matches the shortened "John St"
  • Query passing to report: Rental_Vehicle_Location=John St&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

48. Powell St​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Powell Street Car Park") — previously an exact match on "Crash Claim HQ-Powell Street Car Park"; the "Crash Claim HQ-" prefix is dropped now that it's a .contains() match
  • Query passing to report: Rental_Vehicle_Location=Powell Street Car Park&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

49. Mark St​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Mark St Carpark Lidcombe" || "Crash Claim HQ-Mark Street - Holding Yard" — unchanged; still an exact match on the full string, not migrated to .contains()
  • Query passing to report: Rental_Vehicle_Location=[Crash Claim HQ-Mark Street - Holding Yard,Crash Claim HQ-Mark St Carpark Lidcombe]&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19 — only the Vehicle_Status_op code changed (27→19); no Rental_Vehicle_Location_op was added since this is a bracket-list OR, not a .contains()
  • Report filter: same as "Query passing to report" above

50. Crane St​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Crane St Carpark" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Crane St Carpark&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26 — note the added Rental_Vehicle_Location_op=26 ("contains") despite the criteria still doing an exact match; see the group note above
  • Report filter: same as "Query passing to report" above

51. Hillcrest​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Hillcrest Carpark" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Hillcrest Carpark&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

52. Basement​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Basement" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Basement&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

53. Recto Section​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Recto Section" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Recto Section&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

54. Backwall​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Back wall" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Back wall&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

55. CC HQ Wash​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-CC HQ Wash" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-CC HQ Wash&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

56. Assessment Lane​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location == "Crash Claim HQ-Assessment Lane" — unchanged, still an exact match
  • Query passing to report: Rental_Vehicle_Location=Crash Claim HQ-Assessment Lane&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

57. Decal​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Decal") — base clause parenthesised on this tile; previously Vehicle_Location_Type.Place_Name == "Decal"
  • Query passing to report: Rental_Vehicle_Location=Decal&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

58. Parked on Street​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Parked on Street") — previously Vehicle_Sub_location.Sub_Location_Name == "Parked on Street"
  • Query passing to report: Rental_Vehicle_Location=Parked on Street&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

59. Other​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Other") — base clause parenthesised on this tile; previously Vehicle_Location_Type.Place_Name == "Other"
  • Query passing to report: Rental_Vehicle_Location=Other&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

60. Internal/Mechanical​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Internal/Mechanical") — base clause parenthesised on this tile; previously Vehicle_Location_Type.Place_Name == "Internal/Mechanical"
  • Query passing to report: Rental_Vehicle_Location=Internal/Mechanical&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

61. Cleaning Service​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Cleaning Service") — base clause parenthesised on this tile; previously Vehicle_Location_Type.Place_Name == "Cleaning Service"
  • Query passing to report: Rental_Vehicle_Location=Cleaning Service&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

62. Tyres​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Tyres") — base clause parenthesised on this tile; previously Vehicle_Location_Type.Place_Name == "Tyres"
  • Query passing to report: Rental_Vehicle_Location=Tyres&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

63. Quality Yard​

  • Criteria: Base + Exclusion, plus Rental_Vehicle_Location.contains("Quality Yard") — previously a two-part condition (Crash Claim HQ + "The Quality Yard"); now single, and the "The" prefix is dropped
  • Query passing to report: Rental_Vehicle_Location=Quality Yard&Vehicle_Status=[On Hire,Free Hire,IITR On Hire,Sold,Grounded]&Vehicle_Status_op=19&Rental_Vehicle_Location_op=26
  • Report filter: same as "Query passing to report" above

64. Vehicles Without Location​

  • Criteria: Vehicle_Active == "Yes" && Finance_Type != "Short Term Lease" || Finance_Type is null && Rental_Vehicle_Location == "" — previously used Finance_Type != "Cross Hire" (the Cars/Bikes-style exception called out here before); now uses the standard Active Fleet Base finance clause instead
  • Query passing to report: Rental_Vehicle_Location_op=29 ("is empty") — unchanged
  • Report filter: same as "Query passing to report" above

Bottom Tab Strip (html_snippet12)​

Custom Deluge HTML block. Renders an embedded view based on input.tab:

tab valueReport/page rendered
1 (or unset/other)Fleet_Financiers
2Vehicles_to_Be_Financed_1_0
3Loan_Cars_at_Repair_Shops
4All_Vehicle_Movements
5Pending_Purchase
6All_Vehicle_Purchases
7All_Vehicle_Purchase_Requests

Embedded Report​

ElementTypeLink name
ReportZoho report gridOn_Hire_by_Rental_Recovery_Type