Enter your PIN to access this dashboard.
Last Data Sync: Today at 11:17:38 AM
Import your full Flex Inventory Catalog CSV to categorize items automatically. New items will be added without wiping manual overrides. Uncategorized items will be highlighted in yellow in the backend sheet.
Configure the conditions used to filter out touring jobs from the Staff Load Calendar and Google Calendar integrations.
| Department | Target Scans/Hour | Core Staff |
|---|---|---|
| Loading metrics... | ||
Configure the maximum number of staff available per day to identify when events will push capacity into the red.
Configure role-specific daily capacity ceilings. Any role appearing in Flex quotes or Lasso shifts that is not explicitly assigned to a group will automatically fall into the Other / General bucket to guarantee total reconciliation.
| Date | Holiday Name | Action |
|---|---|---|
| Loading holidays... | ||
| Date | Hours | Staff | Scope | Action |
|---|---|---|---|---|
| Loading special shifts... | ||||
| Loading... |
|---|
| Loading matrix... |
Every scheduled hour below, the background automation scans active logistics logs and automatically compiles/emails separate alert warning digests for:
โข ๐ Active Operational Conflicts (urgent/moderate scheduling conflicts)
โข โ ๏ธ Overdue Warehouse Tasks (overdue prep, loading, or return checklists)
โข ๐ฆ Sub-Hire & Rental Prep Alerts (reminders for pending outsources)
Configure active status, dispatch days, and delivery hours for automated background email summaries.
Summarizes Inquiry-to-Tentative/Confirmed progress over lookback timelines.
Sends daily operational logistics agenda to crew leads.
Sends weekly digest of assigned events starting in the next 90 days, crew shifts & call times, booked vehicles, and logistics requests.
Sends alert warning digests at custom dispatch times configured above.
Generate and email a high-quality PDF status change report manually for any custom date range.
Jobs belonging to any Account Manager listed here will be filtered out and excluded from all compiled weekly/manual status change report PDFs and emails.
Configure internal costs for transportation zones. "Zone 4" corresponds to Toronto.
| Loading... |
|---|
| Loading rates... |
Configure the default labor overhead (loading/unloading duration in minutes and crew size) required for each owned vehicle. This will be used in future workload calculations.
| Vehicle Name | Lasso UID | Handling Time (Minutes) | Staff Required (People) |
|---|---|---|---|
| Loading fleet settings... | |||
| Name | Role | PIN | Action |
|---|---|---|---|
| Loading users... | |||
| Integration | Status |
|---|---|
| Flex API | ❌ Not Configured |
| JotForm API | ❌ Not Configured |
Live sheet statistics, Script Properties, CSV header alignment, and server execution logs.
View a real-time audit trail of all user actions and system events.
Open Log ViewerCaptures live user actions (clicks, RPC mutations, triage updates) into the Cloud SQL journal to enable on-demand shadow replay testing against Cloud Run.
Captures real-time JavaScript runtime errors and unhandled promise rejections across all employee devices directly into Cloud SQL and Google Cloud Error Reporting.
Permanently delete data older than the configured window (14-30 days).
Add a new email address to the matrix.
These are the Default Blueprints. When you create a new user or change their role, they will inherit these exact settings as a starting point. Changes here apply only to NEW users or when a role is changed.
| Role Name | Main Dashboards | Management Pages | Specific Actions | Action | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Template | To Do List | Emergency | Schedule | Warehouse | Staff Load | Warehouse Load Calendar | Conflicts | Triage | Logistics | Shortage | Procurement | PM Payroll | Analytics | Quote Forecast | Turnaround | Marketing Planning | Calendar | Logs | Admin | Manage Users | Purge DB | Mark Complete | Edit Times | Action |
| Loading templates... | ||||||||||||||||||||||||
Customize granular access for each user. Changing the dropdown under their name resets their row to the Role Template defaults.
| User & Role | Main Dashboards | Management Pages | Specific Actions | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | To Do List | Emergency | Schedule | Warehouse | Staff Load | Warehouse Load Calendar | Conflicts | Triage | Logistics | Shortage | Procurement | PM Payroll | Analytics | Quote Forecast | Turnaround | Marketing Planning | Calendar | Logs | Admin | Manage Users | Purge DB | Mark Complete | Edit Times |
| Loading matrix... | |||||||||||||||||||||||
Tasks targeting this date will automatically be shifted to the nearest working day.
Override standard hours (e.g. for a working weekend or extended shift).
Preview or dispatch test emails directly to your testing inbox without notifying live clients or crew.
[TEST] subject prefix.
Select a Project Manager to preview or email their 90-day upcoming schedule summary.
Trigger a live test of the branded Assignment Notice with labor role bubbles and Flex link.
API Keys are securely encrypted in script properties and never written to the spreadsheet.