Geocoding in Appsheets

[BobSig]

I am unable to make Geocoding work within my Appsheet app.  I am confused when reading the little information I could find regarding the set up within AppSheet.  I am not a programmer.  I want to have a map view, showing the location of homes to which we will be providing service.  I have a Homes table with a concatenated column, set to Address type, which includes the Address, City, State, Zipcode and USA. (Example: 858 Montebello Camp Rd, Imperial, MO 63052, USA)  I also have a column named Location which is of the LatLong type.  I cannot figure out the required steps to have Appsheets update the LatLong column upon Adding/Saving and/or Edit of the Address Column.  I have downloaded the Appsheet Template Geocoding with Appsheet.  In that template I entered and address, but it did not place the LatLong information into it's sheet.  Does someone have a video or tutorial pdf showing how to set up this functionality.  In my app, if I manually enter the LatLong informaiton, my map shows the pin placement correctly.  But as I mentioned, if I enter only the address, the LatLong information does not populate the Location column.

[Steve]

I'm not aware of a way to do what you want with AppSheet itself.

[Suvrutt_Gurjar]

As Steve guided there is no native way to do the needful.  You may want to consider using Google Apps Script based on your use case.

Class Geocoder  |  Apps Script  |  Google for Developers

[BobSig · Accepted solution]

I used the Geocoder template as a guide and also signed up for the google api.  After many changes/attempts, I was able to make the Geocoder return the LatLong values for an address and add the LatLong value to my table.  Which, in turn, allowed the map view to place a pin at the address location.