Map View Error

[mamorimc]

When i use the function HERE() to pick up the location, the function is recording it on appsheets database in a way that the map view doesnt work.

 

 

I'm having an issue with the Appsheet Database Latlong field type, where when a registry is saved(either new or updated), the dots from the coordinates arent saved. 

Example:

Real coordinates: -26.2844405,-48.8413516

The app saves them as -262844405,-488413516, which in turn makes it impossible to update this specific row due to the invalid type.

It works fine if I use a Google Sheet as the database. I thought it might be related to formatting issues(I'm in Brazil, so we use dots where the americans use commas in numbers and vice versa, it's a common issue), but changing the localization didn't help.

Any help?

[eangelc]

Hi @mamorimc

You could customize the app's behavior based on the users' location. You could use the User Settings: The Essentials 

[Fabian_Weller]

Here is the solution: In the Database we have to set the Table locale to "English (United States)". Then the LatLong will get saved with dots.

The table's Time Zone and the Data Locale in the AppSheet Table Settings can be set to any other.