OSC Request Tracker System
A web-based request tracking system that provides real-time status updates, queue visibility, and progress tracking.
The Problem
- Lack of transparency
- Constant follow-ups
- No progress visibility
- Manual tracking inefficiency
The Solution
A lightweight web app connected to Google Sheets that allows users to track requests in real time using a tracking number.
Key Features
🔎 Tracking Search
📊 Real-Time Status
📍 Queue Position
👤 Assigned Personnel
🧭 Timeline Progress
📅 Date Tracking
Interface Design
The interface uses section-based cards to group related data such as Request Details, Assignment, Timeline, and Queue.
System Flow
Input Tracking → Fetch Data → Display Structured Result
Tech Stack
- HTML, CSS, JavaScript
- Google Apps Script
- Google Sheets
- GitHub Pages
Queue System Logic
Requests are filtered by OPEN status and sorted chronologically to determine queue position dynamically.
Example: 16th in line (17 open requests)
Progress Visualization
A timeline replaces text-heavy statuses for faster understanding.
Challenges
- Column indexing issues
- API response debugging
- UI hierarchy refinement
Outcome
- Reduced manual follow-ups
- Improved request transparency
- Created a scalable internal tracking system