Overview
A task board that organizes a CS department’s issues and deals by category and shares progress across the team — existing-customer issues, new deals, internal tasks, and incidents — bilingual in Japanese and Chinese.
Problem
Status was scattered across chat, email, and spreadsheets, so no one could see who was carrying what. A mixed JP/CN team added a language barrier.
Approach
Records are kept as a task → progress → supervisor-comment hierarchy over time. Input language is auto-detected and synced with a separate translation workflow (HMAC-signed HTTP integration, idempotent) to fill JP/CN both ways. A per-assignee weekly report is emailed automatically every Friday at 6 PM.
Key features
- Four-category board grouped by assignee
- Time-ordered thread of task → progress → supervisor comment
- JP/CN language detection and translation sync (two-way fallback)
- Automatic weekly report email (weekday/time configurable)
- Structured deal data for new opportunities (win likelihood, expected revenue, type)
- Role-based permissions and audit log via soft delete