Update data in real time

[Paulo_Martins]

Good afternoon! I made a bot that calls a script that should return the geolocation address but this only happens after the application is saved. Is there a way to do the field update in real time? Thanks!

[Denny774]

Hey man,

just use the HERE() function in the initial value of that field.

Cheers

[Paulo_Martins]

Hi,

I do it  to map, but i need reverse geolocalizantion. Here() function response lat, long

[Denny774]

Hey I  see,

you can do so with a simple HTML link to google's geocoding API. All you need is an API key to authenticate your request
eg.: 
https://maps.googleapis.com/maps/api/geocode/json?latlng=40.714224,-73.961452

[Paulo_Martins]

This is how the application is currently, but in this solution it only updates after saving and I need it to update when starting the application

[Denny774]

Hey,

can't you use virtual columns and/or actions instead?

[Paulo_Martins]

I'll research about

[Paulo_Martins]

Can I call a bot or actions using a formula?

[Denny774]

Hey,

not that I know of.
But you can change a random field that doesn't even have to be synced back to the Database to trigger an Action. Actions occur and get triggered on the Client-side.
You should learn about the "Quick Update System" in AppSheet by searching for it in the Forums

[Paulo_Martins]

I'll search