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
Effective
Enter a clock time later today to schedule the deactivation for then. Enter now (or leave blank) to deactivate immediately. Past times are treated as "now".
Shift end
Expected return
Expected return is for information only — it does not put the tech back on the schedule. To re-add the tech, send a separate "Available again" update.
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.
Add Tech — mid-shift, part of the day
Adds one tech to the live schedule for a set window when you get busy — no need to redo the whole schedule. The router starts using them at the Start time and automatically drops them at the End time.
Tech name
Role
Territory
Start timeEnd time
Start can be a clock time (3pm) or now. End is required — the tech is removed from routing at the End time.
Reason
Email Preview
To:
Subject:
Management Notice
Tech
Tech email
Manager email
Sent from the PAL NNJ Pay account directly to the tech, copying the manager.
Boilerplate — always included
Issues to include — highlighted items are sent
Check each issue that applies. Only the highlighted issues appear in the email.
Email Preview
To:
Subject:
Bonus Impact
Tech
Tech email
Manager email
Bonus impact
Sent from the PAL NNJ Pay account directly to the tech, copying the manager.
Boilerplate — always included
Performance problems to include — highlighted items are sent
Check each problem that applies. Only the highlighted problems appear in the email.
Shift
Minutes
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.