I don't have a solution. Here is what I experimented with.
driverSelectionExampleMustafaData.aia (18.3 KB)
It might help you come up with a solution.
-
Add a column H to your Web_import url code
https://docs.google.com/spreadsheets/d/15Ayd3SAJTSWLixQsLqvhIo7ijrSwU2f3sapIVzRdKQ8/gviz/tq?tqx=out:csv&range=A2:G200&tq=SELECT B,C,D,E,F,G -
I added an H column so that each user has a value of 0\n. When you do this it allows converting the spreadsheet values to a csv Table. (Mustafadata.csv).
Mustafadata.csv (267 Bytes)
Column H can be used for time. I used the 0\n to get the data that your Web_import added to the original csv. All entries need it but the last entry must not have the \n . The link you provided worked to capture Hassan once, then when I returned to the docs.google document, Hassan was no longer there. I guess you are modifying the document See Mustafadata.csv where I showed how I think the csv should look. When you add an new time with a more recent time, you should not add the driver as a new item, you should REPLACE the previous position.
I load the csv file from an asset. That means you will have to store the modified version in the app's private storage ASD app specific instead. I don't show how to do that. (Asset: Files are read from the app assets. It is an error to write to app assets as they are contained in read-only storage.)
-
you are trying to enter each driver with a sequential id number. Doing that complicates the coding. Instead I suggest everyone gets a permanent id perhaps.
-
The csv Table is named as fullDriverCSV in the File1.GotText block.
-
Create the fullDriverList in Button3 and by assigning fullDriverList to list from scv table text fullDriverCSV (see the Button3 code) . This lets you use what is now a List to calculate the nearest driver
-
run the example. First press the get Spreadsheet contents button to load the csv. Then use the Find nearest driver Sort destinations button. Then you can Post All Drivers Locations. to see where all the drivers are. When you sort, Ahmed becomes the nearest to my location (because I use the LocationSensor to set the customer and I have to use my gps location with the LS to provide an example).
Hope this jumbled discussion helps you fine a way forward.