I need to build a Heat Map for our executive team displaying saturation of certain geographically defined areas. Sadly, QB doesn't allow for a heat map organically, and most tools require the use of ...
I have a subscription to google cloud for many various projects I work on outside of quickbase. So the api key is no issue. I can export the data and re-import it with updated lng/lat information for all existing locations. But if I wanted to update a location as it comes in what would be the best route here without paying a fortune to have an addon installed to quickbase.
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.