Just great! My wife leads summer children camp and they do a lot of Qwest games. Now we will help them do it digital
Hi Jack Would it be possible to use the Distance Computed Column updates to plot a point on a map with a marker indicating the userās current location and continuously update the marker to a new location as the user moves?
Hey, Were you able to use this feature, as for me as well it does not work and keeps spinning. Not sure if i am missing something.
Maybe you have ever chosen ādonāt allow to use your current locationā. Try in settings or clear cache memory from the browser where you installed the app.
Did the issue regarding tracking a userās location over time get solved? I am interested in this.
I donāt think itās possible as of now. The computed distance column only gives you the distance, not the āliveā coordinates.
Is there away to track another personās cell and calculate the distance from certain locations and share with others?
Using just Glide? They would need to toggle that location toggle. But using scriptsā¦oh yeahā¦there is a couple of ways, some wouldnāt require permissions and others would.
The distance column will track a userās distance locally on the device. To share the distance or a location with others, it will take some sort of action from the user, such a flipping the location switch and updating a column value or submitting a form. You canāt share your location to others in real time automatically.
Thank you
I am working on it.
I think I have come up with a solution.
Iām curious what your use case is. I have a location based app and will be looking to match people that are in the same vicinity.
How close is your proximity to determine āvicinityā. If your looking for within 10 to 20 miles or above you can plugin an api that does this for you thats 100% free up to 10,000 requests per month!!!
This api is 500 free per day and only $6.99 a month for 5,000 a day
Jeff, there are ways to do this within Google Sheets.
How would a google sheet have knowledge of a current dynamic location of an active glide app user in real time?
Tracking cars
Because the app is a PWA pretty much.
Care to elaborate? Based, on those APIās you shared, they only locate based on IP, which can be somewhat broad in area (in some cases, my IP registers as 3 states away) and in any case, there is no glide functionality to obtain a userās IP address. That aside, if you use an API to obtain coordinates through the new API column, or simply use the location component to obtain accurate GPS coordinates, it still requires action from the user to take the coordinates (stored locally) and physically write them to the sheet. I guess my question still is, how is a google sheet aware of an app userās physical real time location (like Glympse) without any action from the user? As far as Iām concerned, a Glide app is not aware of a google sheet at all, since it is in direct communication with Glideās servers and internal database. Itās the internal glide database on the server that then syncs with the google sheet. There is no direct connection between app and google sheet.
Those were examples, not ones I use, but those as you mentioned are based on IP addresses that triangulate with a cell phone tower and whenever you leave that towers range you are provided a new ip. Those towers depending on where you live and the type of service provided are within 10 to 20 miles of each other as far as radius. When it comes to congested cities they are even closer meaning you could pinpoint within a 3 mile radius.
I understand how triangulation from towers works, but that still doesnāt explain how a glide database or google sheet can see and track the real time location of every app user as it relates to a glide app.
How could I as an app user see the location of another app user in real time using scripts as you described?