Fiber911 — Locate Ticket Manager

Paste Received Work Order

Paste the raw text from the city's locate work order email. Fields below will auto-fill — review and edit before saving.

Work Order Details

Ticket # — will be assigned on save.

Emergency Locate

Incident #

Issued By

Contact Email

Address Number

Street

Permit?

Permit #

OneView ID

Approximate Address

Lat/Lng Coordinates

Origination IP

Description / Marking Instructions

Time City Received Request

Time We Received Work Order

Site Map / Locate Diagram (optional)

Screenshot or photo of the locate area map. If Google Sheets Sync is configured, it's also uploaded to a shared "Fiber911 Locate Maps" Drive folder (named by incident #) so other devices can see it too.

Active Tickets (Sheet)

Shared with everyone on the Google Sheets link below. Sync pulls in tickets other users created or completed, and pushes your own changes up.

Not synced yet

Debug Log (what actually happened, right on this device)

Shows real sync errors and any JS errors as they happen — use this instead of a computer's dev tools when troubleshooting on mobile.

(no log entries yet — tap Sync Now to generate some)

Complete a Ticket

Select an open ticket, fill in completion details, and submit. It will move to the Completed Log.

Not synced yet

Paste Completion Invoice (optional)

Matches the invoice's Work Order # (or address) to an open ticket, and fills in hours and footage. "Completed By" still needs to be entered manually — it's not on the invoice.

Open Ticket

Completed By

Date/Time Completed

Time To Complete (hrs)

Footage of Cable Traced (optional)

Invoice # (optional)

Completion Notes

Completed Log

City Map

Green = open, under 48 hours. Red = open, past 48 hours — needs attention. Blue = completed. Tap a pin for details.

"Active" shows all open tickets plus anything completed in the last 7 days. Older completed tickets move into the 7–30 and 30+ views instead of cluttering the main map.

Open (<48h) Overdue (>48h) Emergency (open) Completed