From an adreess field to a Latlong field

Hello friends.

En México we put the street name first and then the number.

What are the specific fields or information to get from an address field to a Lat, Long field?

Sorry, mate sounds too easy for somebody but not for me.

Regards

Hi @Alejandro_Lamo1

As far as I know there is no direct option to get address from latlong or latlong from address.

However, with a bot you can call a script that will do the job for you.

basically:

  • you enter an address

  • you call a script that will convert your address into lat/long, with a “return” part

  • you set your bot to use the “return value” and write it down in the expected column or your row

Here is a sample app:

Geocoding with an Apps Script

For reference:

Call Apps Script from an automation - AppSheet Help

Use return values from Apps Script tasks - AppSheet Help

AppSheet automation: The Essentials - AppSheet Help

1 Like