Update Existing Records with Addresses with Geolocation

[jbloome]

Hello,

I've successfully used the Caspio script: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-generating-geolocation-coordinates-from-web-form-submissions/ andhttps://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/

to geolocate an existing record with an address  by using a tabular report with a html block to pass a variable (Home_ID) to a reports detail page. 

The scripts work great but what I am trying to figure out is how to automate the process to update all of my records with the geolocation (I have more than 7000 entries) without having to manually pass each record through the tabular report to the reports details page (so it can activate the geolocation script).    Any ideas for a script to do this?  

[jbloome]

I think I found an elegant solution.  I found a free Google Sheets Extension Called Geocode by Awesome where I can download my addresses to Excel, geocode them with the extension and  then reupload them  back into my caspio database  with the geocoding.  

[GoodBoy]

Hi! Yes, I believe there is a different script when bulk updating the geolocation of existing records, but it is great that you have found this excellent workaround! It will help me a lot and other Caspio users as well! Thank you!  

 

Cheers!