When capturing geocoordinates that requires high accuracy, instead of using the formula here(), it is recommended to remove the formula and use the icon that shows in the app for the latlong field type. This approach forces appsheet to wait the accuracy to improve for 30 seconds or the accuracy reaches 10m and the user interface shows the live accuracy level. Is it possible to capture this accuracy in the data?
Hello @Floribert, you can check out the below link for more information-
Thanks @Shourya_Tomar for sharing the resource. However, it doesn’t touch my main challenge (i.e. by clicking the location button, you see the accuracy in meters but you can’t capture it in the data which means that apart from the data collector, no one else can know how accurate the location is).
You may find it helpful to review this video tutorial to see if it addresses your current issue.
You have to use a column of type LatLong and let the user choose the location. When the user chooses the location, the higher-precision location will be returned. It appears it is not possible to access the high-precision without user interaction, but you could try by using HERE() in the input column’s Initial value expression.
One option could be to use a number type column just below the latlong column to capture the location accuracy. A little offbeat option but I believe will easily do the job if user is trained to immediately record the accuracy once it stabilizes. There can be even a show column to alert the user, something like below GIF shows.
I believe the user will have ample time to record the accuracy, because testing showed that once the highest accuracy is achieved, the latlong as well as accuracy captured by map stays put till form is saved.
I used an SVG code ( code credit to Gemini) to mimic the location accuracy as I was using a GIF maker with 10 sec record limit and on desktop where I believe the location accuracy is not captured.
The user keeps moving the slider on the number column as the accuracy improves and stabilizes. The number column has an initial value of 10 meters so that the user can move it either ways in the range ( 5 to 18) depending on the accuracy captured. The user can even simply enter the number with a keypad instead of the slider control.
Please refer the GIF below.
Yet another option ( a bit longer) is the user can take a screenshot of the map, crop it and save in mobile and upload it as an image in another column, if your app security /confidentiality measures allow it.
This way a more permanent record of the accuracy distance is available. The procedure of taking photo, cropping it , saving it and uploading it in an image column takes around 15 seconds.
@Suvrutt_Gurjar Though a bit longer as you said, so far this looks like the most accurate way to capture the the accuracy info (and it can be combined with the AI task that can scan the screenshot and record the accuracy in a specific column).
Hopefully this is on the google dev pipeline (i.e. capturing both accuracy and altitude in the geodata). Kobo does this well but lacks advanced features appsheet has and it’s not a good experience for users to use multiple applications for just one field.
Thank you @Floribert for your revert. Good to know you like the image capture suggestion.
Yes, absolutely. This would fall into a sweet spot of the native AppSheet AI integrations of extract data from images.
Hello all,
Thank you so much for sharing all of this valuable information!
As a friendly reminder: if the solution provided above resolved the issue for you, please take a moment to mark it as the accepted solution.
By doing this, we are helping others creators facing the same challenge to find the answers they need.
Have a great weekend!
Since it seems this information is critical to your app, why wouldn’t you want to implement your own API call to retrieve the details you are interested in?
Any manual process will be prone to error and INACCURATE results.
Usage of the Google Geolocation services is free up to 10,000 calls a month!!
