Sales Dashboard

active
Total logged
21h 15m
Uninvoiced
0h 0m
Entries
6
Invoices
0
Time by team member
Team memberEntriesHours
Caleb Harvey621h 15m
Recent time entries
Last 6
DateDescriptionWhoDurationStatus
9 Apr 2026- Investigated TV browser limitations with FileMaker authentication prompts - Designed alternative login workflow using OData-based authentication - Developed custom login page for dashboard access control - Implemented credential submission and validation process - Added session persistence handling for unattended TV display usage - Updated dashboard launch process to bypass missing auth popup issue - Tested authentication flow on TV browser hardware - Refined login UI for simple remote-control navigation and readability - Performed end-to-end testing of secure dashboard access workflow - Final production deployment, troubleshooting, and handover supportCaleb Harvey3h 15minvoiced
8 Apr 2026- Implemented secure hosting workflow for dashboard assets on FileMaker Server - Configured secure folder access and authentication requirements - Updated deployment structure to comply with FileMaker Server security model - Modified OData access handling for protected server environment - Tested dashboard accessibility under authenticated user sessions - Resolved issues related to unauthorised asset loading - Updated refresh scripts to maintain authenticated dashboard sessions - Improved server-side handling of secure JSON retrieval requests - Performed validation testing across internal network environments - Conducted deployment and security verification for production releaseCaleb Harvey3h 45minvoiced
7 Apr 2026- Updates to Brochure column formula on Sales Live Report - Was showing brochures sent rather than brochure requests created - Show created ones as the new formula - SuccessCaleb Harvey0h 45minvoiced
7 Apr 2026- Finalised front-end dashboard display and table rendering - Enhanced styling consistency across rows, headers, and totals - Added last updated timestamp and auto-refresh countdown display - Improved JSON payload structure for reliable parsing - Implemented refresh handling to minimise screen flicker on TV reload - Tested dashboard stability with large live datasets - Refined FileMaker scripting for scheduled data rebuilds - Added error handling for missing or malformed dashboard data - Performed cross-device testing on TV browser environment - Final review and deployment preparation for production rolloutCaleb Harvey2h 45minvoiced
2 Apr 2026- Continued development of dashboard aggregation scripts - Added support for Brochures and Meetings activity metrics - Built total row calculation and summary logic - Developed JSON formatting structure for OData consumption - Created scheduled refresh process for automatic dashboard updates - Refined TV-safe responsive layout spacing and typography - Added handling for inactive RM records and zero-value displays - Improved performance of dashboard generation queries - Tested OData endpoint integration with external dashboard page - Conducted live data validation and bug fixes across all metricsCaleb Harvey6h 0minvoiced
1 Apr 2026- Initial project planning and architecture for TV-based sales dashboard - Designed FileMaker data structure for dashboard metric aggregation - Created dashboard source table for JSON snapshot storage - Developed scripts to collect RM activity metrics from source tables - Built calculation logic for Quotes, Converted Jobs, and Outbound Calls - Began layout/UI design for large-format TV display - Implemented dark-theme dashboard styling for readability on TV screens - Configured automated JSON generation process in FileMaker - Tested initial metric outputs against live CRM data - Performed optimisation of script timing and refresh workflowCaleb Harvey4h 45minvoiced
Stages
  • 3.2
Edit