No, sorry, it is you to prepare that example
And if you need help while preparing the example, then provide a screenshot of your relevant blocks
Taifun
its ok, alright let me show you how is my app working
before the queory i was readying the data like that
and running read all and delete funcions
reading the items data like that
there is two listviews
list view customers orders
list view drivers orders
when the driver select the customer order and send to my orders
then he is deleting it from the listview elements and from the customers sheet data and send it to his listvew drivers and to drivers sheet data like that
so after the query it made an error as it didnt show all the data again when selecting the listview order
i hope to get me now so lets show me what can i do and where can i send the query
btw this is how i added both queries
I have been following this thread loosely, at least just the parts that come through in English.
It sounds like you are doing an app to support multi-passenger commercial taxi or bus transport to multiple destinations.
I see you tracking drivers and customers.
But I don't see you tracking trips of vehicles (multi-step sequences of vehicles tracked through time across multiple destinations, with different assignments of drivers and passengers from step to step.)
The airline industry calls them Flights.
Again
Taifun
can you show me more about that method?
so if we are tracking flights then how can we give drivers the customers data, Name, Phone Number and location?
That's a good question.
I guess the answer would depend on the business processes of the business.
For example, should the app support dispatchers?
this is an app who the customer can make his travel order from a line to another line
and these data should be arranged to collect numbers of travelers to make the car full number completed and then any driver can select what is near and fit to him, if you have a better idea lets show me more about it
It sounds like you have your design in hand.
Like the old saying goes, Too Many Cooks Spoil the Broth.
so how such transportation apps working, if i have another method?
How can they collect arrange and send customers data to drivers?
i will try to sort by all first and then will make another query for getting the sum number
but lets fix my query for removing the first row header as its ruining my list view elements text boxes
i tried both but not working
select B, C, D, E, F, G, H, I, J, K, L order by D, E, F, G, H, I, J, K, L, B, C, offset 1
select B, C, D, E, F, G, H, I, J, K, L order by D, E, F, G, H, I, J, K, L, B, C, 1
as its deleting the first row not the header
To remove the header remove the first item from the list as you are already doing it
What about contiinuing as suggested and prepare an example to understand the concept?
Taifun
its removing the first column not the row
i really would like to make it but couldnt, the issue with how to send the another query in the listview as the driver should get all data when selecing the listview selection to send it to his list with adding his details
The result from the database is s list of lists
Each list item of the main list is a row
To remove the first row means to remove rhe first item
It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.
To get an image of your blocks, right click in the Blocks Editor and select "Download Blocks as Image". You might want to use an image editor to crop etc. if required. Then post it here in the community.
Taifun
Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by 
Taifun.
good morning taifun
here is a small simple project to understand the concept, lets show me how to fix it
as you know when i press on the listview selection, the another query should work to show the another elements from the sheet, name and phone number
so lets show me how can i make it worked to show all other labels while selecting the listview selection
i added queries in buttons to make it easy while selecting the listview selection as it will be permanent not to be changed anymore just to fix it and to get the right where query
Please provide the aia file
Taifun
alright, will send it
Here is your updated example
gVizQueryDemoTaifun.aia (5.8 KB)
sending the first sql statement to the database
sending the second sql statement to the database after picking a row
Taifun
1 Like
Oh wow, thanks so much for your genius blocks, i would never do same blocks without your help,
one last thing please, i need when select the listview 1 selection, the listview 2 seletions can be selected as well something like that
so i can transfer the data from the listview 2 with selecting the listview 1
same as the screenshot above so when i select the listview 1 selection, both listview 2 selections can be marked