How lalitkumarjogi/complain-project works
This is a Google Apps Script service-complaint and field-service management web app, implemented largely as a monolith in Code.js. The principal workflow runs from complaint submission through ticket creation and confirmation, coordinator assignment, engineer service reporting and file upload, then accounts reconciliation and dashboard viewing. The README documents the domain stages and integrations; the excerpts show ticket generation, email handling, cache operations, role-based report filtering, and browser UI behavior. Because the source is partial, links for other documented features rely on the README rather than inspected implementation.
Main entry points: Code.js Ticket Registration
Components 18
Complaint Intake
- Complaint Form
Code.js - Ticket Registration
Code.js - Email Confirmation
Code.js
Service Operations
- Engineer Assignment
Code.js - Legacy Name Migration
Code.js - Service Reports
Code.js - Photo and Document Upload
Code.js - Google Drive
Records and Performance
- Google Sheets
- Chunked Read Cache
Code.js - Invoice and Payment Records
Code.js
User Interfaces
- Admin and Accounts Dashboard
Code.js - Ticket Status Tracking
Code.js
Other components
- Customer / Client
- Coordinator
- Field Engineer
- Accounts Team
- Gmail / Mail
Connections 21
- Customer / Client → Complaint Form: submits complaint
README.md - Coordinator → Complaint Form: submits request
README.md - Complaint Form → Ticket Registration: registers complaint
README.md - Ticket Registration → Google Sheets: writes complaint
README.md - Ticket Registration → Email Confirmation: triggers receipt
README.md - Email Confirmation → Gmail / Mail: sends email
README.md - Coordinator → Engineer Assignment: assigns engineer
README.md - Engineer Assignment → Google Sheets: stores assignment
README.md - Legacy Name Migration → Google Sheets: normalizes names
README.md - Field Engineer → Service Reports: submits report
README.md - Service Reports → Google Sheets: stores report
README.md - Field Engineer → Photo and Document Upload: uploads files
README.md - Photo and Document Upload → Google Drive: stores files
README.md - Photo and Document Upload → Google Sheets: catalogs metadata
README.md - Admin and Accounts Dashboard → Chunked Read Cache: uses read cache
README.md - Chunked Read Cache → Google Sheets: reads cached data
README.md - Accounts Team → Admin and Accounts Dashboard: views records
README.md - Admin and Accounts Dashboard → Invoice and Payment Records: manages billing
README.md - Invoice and Payment Records → Google Sheets: stores invoices
README.md - Customer / Client → Ticket Status Tracking: tracks ticket
README.md - Ticket Status Tracking → Google Sheets: reads complaint
README.md