Pop-A-Lock of Northern NJ — tech names validated against the canonical Google Sheet
Roster: not loaded — strict mode OFF
Shift
Type
Date
Your Info
Role
Name
Phone
Shift time
Backup Manager
Name
Phone
Shift time
Technicians
Email Preview
To:
Subject:
Update Type
Tech Availability Update
Status
Tech name
Territory
Role
Left at
Shift end
Expected return
Reason
Use "Unavailable" when a tech goes off mid-shift. Use "Available again" when they return — or to add a new tech mid-shift (fill in Role and shift hours).
Tech Late — Updated Shift Times
Enter each late tech and their new shift window (e.g. 9am-7pm), or just the new start time (e.g. 9am) to keep the original end time.
No Call / No Show
Enter each tech who did not show up. Only the name is used — the time field is optional.
Email Preview
To:
Subject:
Roster Google Sheet (shared with Scores Composer)
CSV URL
Editor URL
Roster not loaded yet.
Both the Schedule Composer and the Scores Composer read the same Sheet so tech names stay consistent. The CSV URL comes from File → Share → Publish to web → CSV. The Editor URL is whatever's in your address bar while editing the sheet. URLs are saved in this browser's localStorage.
Strict mode: when a roster is loaded, the Open in Gmail buttons refuse to send if any tech name doesn't match a canonical name or alias on the sheet. A popup explains exactly which names are unknown. Add new techs to the Sheet first, click Refresh, then try again.
Current Roster — 0 techs
Pending Emails — 0 queued
These emails were composed while you were offline. Click Send now on each to open it in Gmail and hit send. Then click Mark sent to remove it from this list.
Review before sending
To:
Subject:
Greeting is omitted here — the email Gmail opens will include it.