I want to creat a simulator giving a price, based on distance between origin and destination adress. The distance functionnality, implemented in glideapp isn’t accurate. sometimes, it’s more than 100km, or 8000km around.
I tried to implement the google maps API, unsuccessfuly. Here maps api too.
I tried openroute services, but still the same thing… can someone help me?
Thanks a lot
Mapbox isn’t the greatest at geocoding addresses, but it helps to make sure the address is complete and clearly formed.
But to guarantee accuracy, the distance column works better if you give it coordinates instead of an address. So if you are looking to implement an API, I would look for something that just returns coordinates, and then use those coordinates as the address in your distance column.
Do you want to know/work with the distance based on Driving, Walking, Cycling, etc?
If so, you have to use another way. Glide gives you the distance based on “as the crow flies” only.
I will try it and give you my opinion
I’m working with distance based on driving !
I tried it, now, it’s more accurate, but still more than 50 km arround the real driving distance given by google maps or gere maps… that’s why i want to use another maps api, if it’s possible…
The distance column in glide is straight line distance. It’s accurate as far as a straight line is concerned.
So, how to resolve my problem?
If you want to use Google Sheet as data source and can wait a while to know the result (glide will need to do an update/sync), you might start over here Google Maps Formulas for Google Sheets - Digital Inspiration
If not, I have another solution using a script deployed as a web application: work as an API, you send parameter such as origin, destination and mode of travel (driving, walking, etc) and the script replies with the distance in 3-4 secs. It’s very fast and no API key is needed.
I hope it helps you.
I’m not only looking for google maps solution. and like you said, it’s not interresting from google sheets.
I’m interrested by your solution
How can you help me to do that?
I sent you a DM my friend!
Hi gvalero, I’m also interested in your solution.
Just a curiosity: The new Google Maps Integration doesn’t work for it?
I used to use my workaround when this Integration didn’t exist but now, I’d suggest using it.
Is there something bad with it?