New expression to get address from latlon, or get latlon from address vice versa

[Koichi_Tsuji]

I wish to have simple expression to return latlong from address value, or other way around, to get the address from latlon value.
I only could manage this by writing app script, but it is just wasting time.

I wish to intuitive expression like

getAddress([Latlon])

getLatlon([Address])

[MultiTech]

This has been requested several times… there’s a detailed string about it somewhere.

Geocoding address

It should be possible for us to do. One of the challenges is that all the addresses do not instantly get geocoded (it would take too long). They get gradually geocoded as the app is used. So for example, if there are 1000 addresses in a data set, only a fraction at a time get geocoded. So a virtual column would have inconsistent data.

Knowing this, at the start we treated this as a “display only” capability rather than a true data capability. Every time we consider exposing LatLong([AddressColumn]) as a function, we come back to this issue.

[Koichi_Tsuji]

Thanks Matt! I got it.

For Address column, as the user keeps typing, the app should assist them to complete the address (show candidate etc) and then such address should be made recognizable by Google so that they geocode for whatever use, convert to latlon, show on map etc.

Hope this is in the pipeline.

[MultiTech]

The address column already DOES suggest things, it’s just not as quick as googles predictive auto-complete.

Maybe that predictive power will find it’s way into our apps once AppSheet is more tightly integrated into the GCP!

[Koichi_Tsuji]

Oh, i didnt know that! what a shame.

Yes, definitely this will become more user friendly with GCP!

[APiCC_Conor]

We would love to see this as well.

[Nick_Haschka]

It would be very valuable if AppSheet would make the geocoded lat/long coordinates it has  geo-coded from address column type fields available as a virtual column or simply for use in creating files and reporting. Our use case is to generate a portable KML file that can be imported into google earth. 

[Roderick]

This idea is not currently planned. 

[Osmosis]

Bumping interest in this...

@Roderick @Pratyusha @Koichi_Tsuji