Build guide
Police and Sheriff’s Patrol Officers OS
Police and Sheriff’s Patrol Officers OS: case files and evidence log, connected to shifts, incidents and patrols & checks - calculations, views and example rows already set up.
For: Security officers, firefighters, EMTs, police and corrections staff, lifeguards and emergency dispatchers
- Linked databases
- 7
- Connections
- 3
- Automatic calculations
- 5
- Ready-made views
- 14
What it saves you
- Crimes and incidents you own with reference, offence and file status - files due to supervisors or prosecutors are listed.
- Exhibits with reference, storage location and continuity - every hand-over is recorded for court.
- Hours worked total per shift pattern and per month
- Incidents with an open follow-up stay listed until closed
- Equipment signed out and not returned is flagged
- Certifications count down to expiry with 60-day warnings
How the parts work together
- During the shift: Log patrol rounds → Record incidents linked to the shift
- Handover: Write handover notes → Check "Reports not filed" and "Signed out"
- Monthly: Review hours and overtime → Renew anything in "Renew soon"
Databases inside
Shifts
Every shift with post, hours and handover notes. Incidents during the shift are linked.
7 fields · 1 calculated automatically · linked to Incidents
Views: Roster, Last 30 days
Incidents
Incidents and occurrences with category, severity, reference numbers and follow-up status.
9 fields · linked to Shifts, Case Files
Views: Open incidents, By category, Reports not filed
Patrols & Checks
Patrol rounds and equipment checks with findings, so you can prove what was checked and when.
5 fields
Views: Recent rounds, Issues found
Equipment Issued
Radios, keys, body cams and kit signed out to you or your team, with return date.
6 fields · 1 calculated automatically
Views: Signed out
Certifications
Licences, first aid, weapons or driving qualifications with expiry countdown.
6 fields · 2 calculated automatically
Views: Renew soon, All
Case Files
Crimes and incidents you own with reference, offence and file status - files due to supervisors or prosecutors are listed.
7 fields · 1 calculated automatically · linked to Incidents, Evidence Log
Views: By status, Overdue files
Evidence Log
Exhibits with reference, storage location and continuity - every hand-over is recorded for court.
6 fields · linked to Case Files
Views: All exhibits, Continuity gaps
You get the finished workspace, not homework.
Buy it once for $19 or get it with your membership, then duplicate it into Notion with every field, link, formula, view and example row already set up.
See Police and Sheriff’s Patrol Officers OS →