{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/d6c3676b570e414c87b8365b13fcc312\" frameborder=\"0\" width=\"1152\" height=\"864\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":864,"width":1152,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":864,"thumbnail_width":1152,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/d6c3676b570e414c87b8365b13fcc312-d06c673505c6d651.gif","duration":300.039,"title":"Client Project Tracker","description":"Here's a breakdown of what I built and why:\nDemo: A Client Project Tracker for a fictional web design agency (Pixel & Co), built entirely in Zite.\n\nI chose this project specifically because I wanted to build something relevant to Zite's audience. Agencies and freelancers managing client projects is a real use case, and this could work as a featured template.\n\nArchitecture:\n- 6 relational database tables (Clients, Projects, Tasks, Time Logs, Feedback, Users)\n- Role-based access: Admin portal vs Client portal, determined by the Users table\n- Admin side: dashboard with stat cards + budget tracking + phase chart, project/task/client management, time logging, user settings\n- Client side: project cards with visual phase steppers (green checkmarks for completed, teal for current, gray for upcoming), project detail page with description + budget + feedback history, feedback form with auto-populated fields and star ratings\n\nPages: Login, Admin Dashboard, Projects, Clients, Tasks, Time Log, Settings, Client Projects, Client Project Detail, Client Feedback\n\nThought process: Planned the full schema, relationships, and UX before prompting. Built in phases: foundation first, then realistic sample data, then polish (hover states, empty states, dashboard enhancements, phase stepper redesign).\n\nHappy to walk through any part in more detail."}