Yes. Ours all have a valid street address.

@traci/@nancy - do all your relevant "appointments" in repairshopr have a valid address on them that we could use to automate google maps with?

That would be a requirement for the report to work..

I would be ecstatic to see a report like this. It currently takes me 1-1 1/2 hours every pay cycle to calculate 4 technicians mileage for reimbursement costs and we just added a 5th tech. If I was able to run a mileage report for each tech, that would save me an enormous amout of time each month.

So currently that's how our techs calculate their miles... the basically do a google maps from our office to that location and then do a point to point thereafter BUT quite frankly if that saves them 30 minutes - 1 hour every week to calculate then that would definitely work!

If you could integrate with a mileage tracking company that would be wonderful also... especially with your app becoming more robust... maybe it could be added to the app?

+1 for MSP feature

You could integrate with MileIQ or one of the mile tracking through cellular phone companies.

Here's the kludge I worked up for tracking mileage:

Go to https://<yourrepairshoprwebsite>/ticket_types
If you don't already have one, create a Ticket Custom Field Type ("Standard" as suggested is fine).
Go to Manage Fields > New Field and call it Mileage (or whatever you want).
Now when you to create a ticket you'll have the option to input your mileage. Getting a report of that is the hard part. Maybe RepairShopr could add reports for custom fields. in the mean time:
Go to Admin > Reports > Tickets > Export to CSV and save it somewhere you can find it.
Now we need to strip the numbers out of the custom fields column and total them.
Open the CSV, press ALT + F11 to open VBA.
From the menu Insert > Module and paste in the script between the lines below. This is just a compilation of scripts I found online, there's probably much more efficient ways to do it, but it works.

=============================================================
Option Explicit
Sub GetMileageTotal()
Dim uColumn As String
' if your data is in a different column then change L to some other letter(s)
uColumn = "L"
Dim i As Long, j As Long, r As Range
For i = 1 To Range(uColumn & Rows.Count).End(xlUp).Row
Set r = Range(uColumn & i)
Dim tmpStr As String
tmpStr = vbNullString
For j = 1 To Len(r)
If IsNumeric(Right(Left(r, j), 1)) Then tmpStr = tmpStr & Right(Left(r, j), 1)
Next j
r.NumberFormat = "0"
r = tmpStr
Next i
' Total 10,000 rows in L column and insert result in O2
Range("O1").Value = "Total Mileage"
Range("O2").Value = WorksheetFunction.Sum(Range("L2:L10000"))
End Sub
=============================================================

Press F5 to execute the script. Go back to the spreadsheet and you should have a total in the upper right of the sheet. To save the script for future use you can switch back to the VBA window go to File > Export File and save it somewhere. Then in the future you can just ALT + F11 > File > Import File > F5 and you're done.

I have also a lot of additional ideas for these apps, as i see a great lack of features in these kinds of apps - ive seen a lot. And funnist of all - ive choosen a support system without any native app :) Must be full of other usefull features then:-)

Hi Troy. Friday, i have a meeting with a danish guy, who started a development company in manila for 25 year ago. Now he has arround 60 developers there, and to get his developers started with app programming, the created an ios and android app, which basically can track time and milage. Could that be a start if we tried integrating this app.?

I think if we added something for this it would only be an estimate, as we couldn't determine the exact route/etc unless we used tracking in a mobile app or something.

Aren't there good 3rd party apps for this already? Your techs could get a $0.99 app that they can hit start/stop - and email you a report once a week. Isn't that already a good solution?

It would save me an my techs for a lot of extra work, because in some cases we bill the milage, and then the technitian get it taxfree on his payroll

If one want's to deduct car travel expenses driving log is a must, I wish we had more comments/votes on the topic

Manual log on paper is a pain

This would be an awesome feature I would be willing to pay extra to have this. Especially if it could be linked to a client/ticket but billed to the company instead of the client.

I absolutely agree with this suggestion! My technicians leave the shop and go straight from one appointment to the next.

The Google Maps data is already there in the tickets, so it would be straightforward to create a route and pass that data through to get total mileage for the day/week.

Being able to generate a report would be useful for tax time and employee reimbursement too.

The scheduler system I used before RepairShopr had this ability and it was incredibly useful.