.jpg)
Is your team spending several hours just to submit an accurate mileage report at the end of the day?
You are not alone. Fortune 500 companies still have their employees submit a paper report or an excel spreadsheet with information on the accounts, clients or locations visited, calculate the average mileage they traveled and wait to get reimbursed on the next accounting cycle.
Wouldn´t it be awesome if your employees could log the mileage automatically as they visit each location? With Zoho Creator and Google maps API is now possible. Zoho Creator mobile app enables you to submit forms from your phone when you are surveying the market, visiting clients or simply performing maintenance to your business units.
Enabling the Google Maps API in your online database allows you to get all the power of Google Maps to your advantage and automatically calculate distance between addresses or coordinates. Feel free to test how it works in the Form view below. The API will update your Zoho Creator database automatically providing distance and time between addresses.
The Script you can use to accomplish this connection is shown below.
strFullData = "https://maps.googleapis.com/maps/api/distancematrix/json?" + strAddress1 + strAddress2 + "&sensor=false&key=YOURAPIKEYGOESHERE";
distance = getUrl(strFullData);
If you need support implementing this feature in your Zoho Creator database do not hesitate to contact us.