The new DrillerDB is out of beta.See what's new

Conflict Detection

What DrillerDB warns you about when you put people and vehicles on crews, and how to spot late or at-risk jobs

Conflict Detection

DrillerDB checks for double-booking when you put a person or a vehicle on a crew in the Teams view. It also flags jobs that are running late or about to start on the Board and Gantt views. This page covers both.

DrillerDB does not block a booking outright. It asks you first, and you decide.

Quick Start: Handle a Crew Conflict

  1. Open Scheduling and click Teams
  2. Pick the date you are planning for
  3. Add a person or a vehicle to a crew
  4. If DrillerDB finds a problem, a box opens and explains it
  5. Choose one of the buttons in the box

What DrillerDB Checks

When you add a person or vehicle to a crew for a date, DrillerDB looks at three things:

CheckBox you seeYour choices
Already on another crew that dayAlready scheduled that dayMove to [crew], Add to both (people only), or Cancel
Approved time off that covers the dateOn time off that dayAdd anyway or Cancel
A vehicle with planned maintenance that dayPlanned maintenance that dayAssign anyway or Cancel

If the time off is still pending, DrillerDB adds the person and shows a note: "Added anyway; check before dispatching."

Read the box before you click. It names the other crew, the date, and the time off or maintenance involved.

Step-by-Step: Resolve a Crew Double-Booking

  1. Read the Already scheduled that day box. It names the crew the person or vehicle is already on
  2. Click Move to [crew] to take them off the other crew and put them on this one
  3. Or, for a person who should work both crews, click Add to both
  4. Or click Cancel and pick someone else
  5. Check the other crew's card afterward to make sure it still has enough people

Step-by-Step: Handle Time Off or Maintenance

  1. Read the box. It says who is out, or which service is planned, and on what date
  2. Click Cancel to leave things as they were and choose someone else
  3. Or click Add anyway (people) or Assign anyway (vehicles) if you have a plan, such as moving the service

Late and At-Risk Jobs

DrillerDB also marks jobs whose timing needs attention:

MarkMeaning
AT RISKThe job is due within two days
DELAYEDThe job's scheduled time has passed and it is not complete

These marks show on job rows in the Board view. A banner above the cards counts the highlighted jobs and reads "Review the highlighted rows below." Click the count to jump to the first one.

Time Off on the Schedule

Time off shows on the schedule so you can plan around it:

  • Board: the members line on a crew card marks anyone out in the next two weeks, and each job row says who on the crew is out during the job
  • Gantt: a crew's or driller's lane is shaded on the days someone in it is out. Pending requests are hatched
  • Calendar: time off appears as its own event

What DrillerDB Does Not Check

Dragging a job to a new date or crew on the Calendar, Gantt, or Board does not run a double-booking check. Review these yourself:

CheckLook For
Travel timeDistant jobs back to back. The Board shows the distance from the previous job
Workload balanceA crew with far more work than the others
Skill matchingA certified crew for the job type
Customer commitmentsPromised dates

The Calendar and Gantt do not stop you from scheduling outside working hours either.

Best Practices for Conflict Prevention

PracticeBenefit
Plan crews in the Teams view for the date you are schedulingThe double-booking check runs there
Weekly schedule reviewCatch issues early
Daily morning checkConfirm the day's work
Track actual vs estimated hoursImprove future estimates

Schedule a weekly 15-minute planning session to review upcoming work and address potential conflicts before they become problems.

Troubleshooting

I was not warned about a double-booking

  • The check runs when you add a person or vehicle to a crew in the Teams view. It does not run when you drag a job
  • Check the date. The check looks at the date shown in the Teams view

A person shows on two crews

  • Someone clicked Add to both. Remove them from the crew that should not have them

A vehicle will not stay on a crew

  • Look for planned maintenance on that date