The company in the brink of a new contract with the municipal water company.
We do have a time to send someone to the place of a problem (like a leak). If our people do not arrive on time, a % is subtracted from the monthly contract value.
My idea is for employee to “check” when he arrives at places. So we get location and time he got there.
Example, he checked he is at HQ.
We get a Service Order for Oak Street. We have 30 minutes to get there.
So he looks at AppSheet and it shows he has 30 minutes.
But will he arrive in time if he leaves 10 minutes before the timeline?
Idea would be for the new Service Order address to be inserted into the system. AppSheet then apparently can show the route through GoogleMaps. I suppose GoogleMaps will show the time for the destination.
Idea would be for that “time to destination” to be captured by AppSheet, so I could subtract it from the time available.
So employee could know he would need to leave to location of service order in 10 minutes at most, or he would arrive after timeline.
And that could also allow us to send service order to different employee, who would be closer (in time) to the Service Order location than another employee.