I am trying make an app to help volunteers fill in information collected during site visits. Right now the coordinates I enter directly via the sheet stay the same, but if I enter a coordinate through the app, it gets changed to a number (decimal point is removed) after syncing. I read online to alter my location to the US but that does not fix it.
Are you using the LatLong data type for the column? Note that it is a comma separated PAIR “49.501300, -62.851111”
Hi thank you for replying! Yes indeed I used LatLong and my coordinates look like “51.191324, 4.988944” but after syncing the app they get changed to “51191324, 4988944”.
Check the column in the backend - sheet or database. Make sure that column is defined as STRING or TEXT. If you are using Google Sheets, by default the columns are set to AUTO - which means Google will try to deduce what type the value is. It may be thinking it is a number and converting it - though the final format you show would be weird if that was the case.
PRO TIP: It is strongly recommended that when using sheets, every column is set specifically to text/string type. This avoids any automatic deduction of value types in the sheets. AppSheet can happily convert strings to the necessary type in the app.