From an adreess field to a Latlong field

[Alejandro_Lamo1]

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

[Aurelien]

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