CHP Roster Automation
Automated California Highway Patrol roster placement, removals, assignment notifications, and auditing between Discord and Google Sheets.
Everything in this update.
Changes are grouped by what happened, with the useful detail kept directly beside each item.
Added
Something new was introduced.
/rostercheck validation
Added roster validation before staff place a member into the department sheet.
/assign placement
Added automatic placement into the first open slot for the member's CHP rank.
Automatic member data
Added automatic name, timezone, and badge-number filling during assignment.
Automatic removals
Added roster cleanup that restores the vacant-slot marker when members are removed.
Roster audit
Added auditing to detect mismatches between Discord assignments and the Google Sheets roster.
Assignment DMs
Added member notifications when a roster assignment is completed successfully.
Fixed
A problem or bug was corrected.
Google Sheets integration
Resolved service-account sharing, protected-cell handling, separator-role checks, apostrophe prefixes, and rank-list reset issues encountered during setup.