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.