Hey JondyL
I'm not sure if you’re still looking for a solution to this, but I actually built a Jobber integration specifically around this problem.
It’s called Same Day Openings and it’s available in the Jobber Marketplace. Customers can opt in to being contacted for earlier appointments, and when an opening appears it can automatically find appropriate customers, check whether the job fits the schedule/route, and text them to offer the earlier spot. If customers haven't opted in yet, you can see a list of potential customers to be moved forward and you or your techs can reach out to them manually one by one.
I’m the founder, so obvious disclosure there.
Your description of maintaining a cancellation list and having to bounce through reports/Excel is basically the exact workflow I was trying to eliminate.
If you’re still dealing with this, I’d be happy to personally help you get it set up or hear how you ended up solving it.
