It depends on how you define the logic of an empty row, but basically it should be an if to check that logic and stop the process if the logic is true (the row is indeed empty).
Mine doesnât work
Error An unknown error has occurred, please try again later.
Please use this instead.
Hi ThinhDinh. This code works. But if I want to get 2 locations at the same time. For example, get FROM location and get TO location on the same record.
Please advise or give me script.
Thanks in advance.
This is a very old thread. If you want to geocode an address, I would suggest using Radarâs integration.
I use Radar at this moment. But it canât translate Thai language. Hence, I need some thing to get geolocation and now I got it.
The problem now is, I have so many taxi driver locations and so many customer locations. How to get to shortest location to match some locations for some drivers.
I donât want to display all locations to all drivers simultaneously.
Whatâs your matching flow at the moment? Iâm not sure I would build an app that requires live location like that in Glide.
All drivers will have current location by push location to send current latlong to the system.
Any time, new customers are coming and enter geolocation to the system. At this time, I want to calculate shortest distant to display for any drivers. Not all customer location to be displayed.
I would try adding a distance column to calculate the distance from the âcurrent locationâ of the driver to all other usersâ locations/coordinates. Does that work?
Another problem is location getting from Radar geolocation doesnât display in Google sheet.
Why do you need it in Sheets?
- I would like to collect all locations from driver.
- When driver delivers customer. They need to push location button to send current location back to the system. The Single Value canât get location from that row. It works only from the first row (User-specific column). How to use Single Value to get latest location?
It doesnât matter youâre writing to Sheets or Glide Tables, if I understand you well, wouldnât Glide Tables just work the same way?
Why do you need to use a Single Value column?
How to capture current location and calculate it with all customers location?
Would this work the same way for customers?
No. Customer just enter location in word and I use nominatim.geocoding to get lat long already.
Why donât you use the same location button for customers? Or can they request rides that are not from the same location they are at?
Actually, the current location feature is not correct location. And I allow customer to enter meeting point instead. And nominatim.geocoding works well.