Wrong addressing

Hello,

I used “Google codes” to display adresses on the map => is this correct ? Some adresses are still well mapped (in US instead of Belgium). Example : 9489+CG Schaltin
Otherwise, do you know how to have a nice map with all my addresses, what kind of information should I put in my googlesheet?

My app link : https://nduqe.glideapp.io/

Thanks in advance !

This is probably the best answer to date for correct addresses in the map. Add the script to your sheet and point your map addresses to the lat/long field in your sheet. Thanks to @Dan_Liebeschutz for the well written article.

1 Like

I just upload my sheet to
https://www.geocod.io/upload/

Then just use the lat and long it generates.

definitely use lat,long coordinates.

2 Likes

+1 for geolocation with Lat & Long instead of an address to populate maps in Glide. (or any component that will require an address)

You can be very, very accurate by setting a marker on Google maps then collecting the Lat & Long it returns.

1 Like

Hi @dharmel! I just wrote an explanation article on how to add a custom function script to google spreadsheet from a script source. Can you please check it out and tell me if it helped?

It also has in it a video showing the steps.

1 Like

Thanks for the shout out @Tim_Sullivan

1 Like

I don’t think I could do any better than Dan’s explanation. It’s about as step-by-step ads it gets.

2 Likes

it works perfectly !!! Thanks a lot :star_struck:

2 Likes

I have a big problem with the script in googlesheet allowing geolocalisation 2020-05-29 18_49_21-HappyKids - Google Sheets et 4 pages de plus - Travail - Microsoft​ Edge

Hi,

Google Maps gives you a daily limit to your queries: 1.000

Beyond it, Google punishes you for 24 hours. Many of us have walked that lonely way before :rofl:

Saludos @dharmel

2 Likes

Have you ever tried another service besides Google Maps? I have seen some out there, not sure if they have higher limits daily.

Years ago I knew and worked with ArcGIS software a little, their GIS applications are amazing!!

They had APIs very powerful but I don’t know if those are free yet. Here their web page:
https://www.arcgis.com

Chao @ThinhDinh

1 Like

Thank you I’ll have a look later. Here are some other options I have read about.

thanks ! :sweat_smile:

Thanks @Dan_Liebeschutz. It’s a good solution to the problem of showing an address in its correct location on a map

Great technique but unfortunately it fails if I try to process more than ~125 cells at a time in my arrayformula. :frowning:

Scripts, scripts, scripts, scripts, scripts, scripts!!!Everbody!! (My new Lil Jon Parody)

Google…limits…psh, screw that. Make multiple accts on google, feed data to accts using import range, script runs, what do you do? That’s right you import those results right back into your Glide Google sheet using another import range, thats what you do.