So I have made a type of inventory-field service application, I can track inventory by product then serial number, then where it is - inventory, truck and then where it’s installed to what customer.
Now
I have a truck I want to calculate the daily milage for, from say there were 5 customers that day.
Is there a way to take the column address and automatically open a google maps and it takes the milage total to the google sheet milage total of the day column?
office - customer 1 - customer 2 - customer 3 - customer 4 - back to office then total milage?
total milage is then inputed in 1 column?
Right now I manually take the addresses myself and put them in google maps to do our milage claim for the office but thought there might be a faster way.
Thanks for any advice