Lat/Long

My script does exactly what you want. There is a little additional code that is needed to grab the address from the open form and after geo-coding stuff the lat and lon into fields.

Also many Google services are free and/or don't require a key when used below a rather generous threshold.

Thanks Dan, any guidance on how to get this rolling inside of quickbase? I am unfamiliar with some of the javascript practices and workarounds outside of making buttons inside of qb app.

I suppose I could try the image onload technique or run every added location through zapier parsing the address with the js code to update the record.

This is easy to do and I will create a demo to show you how. I just got in town but I will put this on my to do list and hopefully I will post by Friday (I have several demos and questions that I have solutions for but I have been busy with other work).

BTW this is the message you get if you exceed Google's threshold:

{
  "error_message": "You have exceeded your daily request quota for this API. We recommend registering for a key at the Google Developers Console: https://console.developers.google.com/apis/credentials?project=_";,
  "results": [],
  "status": "OVER_QUERY_LIMIT"
}

Something to note, each row in our "locations" table that has an address field is automatically added via zapier already. So nobody is interacting with quickbase, opening pages, or editing to input this information, unless it is wrong or gets updated after the fact during our routine checks and surveys. 

So I may have to implement this in both our zap and on the quickbase application itself.

I would love to go through and batch these locations without exporting them, but if thats not possible its no problem.

Thank you for your assistance.