Hi!
I don’t know if you had a problem with putting addresses in the map component, but for me, the location pins were showing everywhere but the place I was aiming for.
After figuring out how to make it work properly I wrote a very short story about it in Medium:
This is me trying to put 4 addresses in Tel Aviv:
Before:
After:
Enjoy!
Thanks Dan!
Hi Dan, that’s a clever way of generating the component!
Love the integrated Google Script as well, I also used a script to generate the distance and travel time here.
This is an awesome tip. I just added this script to one of my municipal apps where citizens can report illegal parking issues during a snowstorm. It seems to handle blocks, intersections, and specific addresses without an issue (so far).
Thanks Dan!
This is pretty neat, dude! Congrats!
Excellent your article, Dan. The solution I have used is to write the address on the map of the mapbox website (https://docs.mapbox.com/search-playground/). It gives you the correct way to write the address. Although some addresses cannot be found, in my case it has only been 10% of my searches.
I will test your formula with the addresses that I could not find. Thanks Dan.
Wow! Great to hear it helped Tim! Thanks for the feedback 
Thank you Mauricio! Please let me know here if it did help!
Thank you!
Hey guys/gals, Im brand new here, and I have a google sheet with all of my club members addresses. They are in separate columns, street, city, state and zip.
They are as the original poster mentioned showing up all over the globe too.
So my question is this. I paid for the premium app, how does a non-coder like myself get this to work properly?
Have you had the addresses as coordinates yet?
Coordinates are best and most reliable, but if you use addresses, you need to make sure the entire address is in one column. If your address consists of multiple columns and you can only point the map to one of those columns, then it’s expected to have erratic results. Either use a formula in the sheet or use a template column in the Glide data editor to join all the address columns into one complete address column.
@StinsonOwner: The first task is to use a formula to build the address in a new cell with comma separated values, i.e. street, city, state, zip.
Once you have that, you will be able to convert the new address cell into lon/lat coordinates using the add-on Geocode for Awesome Table.
For more accurate map pins, coordinates are the best choice and the above method will get your there in no time.
@Dan_Liebeschutz thank you for this - it works perfectly!
I am having an issue with the script though and was wondering whether you have an idea how to solve it:
I use array formula to apply the formula to new rows. Every time a new row is added, the formula re-calculates the entire column’s coordinates which causes:
a. some down time before Glide refreshes and shows the pins on the map. This means that maps are not shown for a couple of minutes when a new row is added.
b. “Exception: Service invoked too many times for one day: geocode. (line 11).” - since my app is sending hundreds of requests each day, I reached a limit I wasn’t aware of.
I think it would be great if newly added rows would use geolocation for themselves only without recalculating the entire column. Any idea how to do that?
Thank in advance!
This is best with a script, but also make sure your script is set to only get coordinates if the coordinates haven’t already been retrieved.
Thanks Jeff, I currently use a script that creates a custom formula, then apply it to the address column using array formula. The array formula recalculates the entire column every time a new row is added, which is the issue.
I don’t know how to write code (that’s why I’m here 
) so I asked a friend to help but he couldn’t figure it out 
Maybe I will try this next week when I have time. The idea is the same as yours, but add in that after the calculation we copy the final value and paste it back into the cell so it won’t recalculate again every time a new formula is added.
@ThinhDinh that would be appreciated, thank you!
I’m working on app where I have already successfully managed to achieve the following:
My template is now out of the production stage.
Now, addressing your problem.
Hope it woks for you as it has for me. When I showcase my app, you can it all in action.
Have a good day.
That’s exactly the solution I am looking for - thanks @Wiz.Wazeer!
The part I’m having trouble with is #3 in your solution, I’m not sure how to create a copydown script. For the matter, I am using the script below to create a custom formula, which is implemented in a sheet called “Homes”. Column I contains the full address entered by the user, column J should return the coordinates using the custom formula.
function myFunction() {
}
function GEOCODE_GOOGLE(address) {
if (address!=""){
if (address.map) {
return address.map(GEOCODE_GOOGLE)
}
else {
var r = Maps.newGeocoder().geocode(address)
for (var i = 0; i < r.results.length; i++) {
var res = r.results[i]
return res.geometry.location.lat + ", " + res.geometry.location.lng
}
}
}
}