Google sheet auto sort script code needed!

[Taifun]

@mustafaalbasel

its removing the first column not the row

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.

[mustafaalbasel]

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

[mustafaalbasel]

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

[Taifun]

@mustafaalbasel

here is a small simple project

Please provide the aia file
Taifun

[mustafaalbasel]

alright, will send it

[mustafaalbasel]

here is the file i had to translate it to English
gVizQueryDemo_1 (1).aia (9.7 KB)

[Taifun]

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

[mustafaalbasel]

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

[Taifun]

@mustafaalbasel

one last thing

Are you sure?

For multi select see here

Multiple selection via ListView possible?

I need to create an app for school, where it is possible to select multiple elements that were downloaded from a webservice and are shown using 'ListView'. Right now I'm working with the ListView and can select one element, but I didnt manage to select more neither to save my selection yet. Do I have to work with 'WhenListView.AfterPicking' or ist there another way?

and try for example the table viewer method

Taifun

[mustafaalbasel]

Alright, i will figure it out, thanks for your support

[mustafaalbasel]

Hi Taifun,
sorry for annoying you
How can i make that achieved?
when i select the listview 1 selection, all shown listview 2 can be selected automatically

[Taifun]

ah, you are back again...

@mustafaalbasel

when i select the listview 1 selection, all shown listview 2 can be selected automatically

the suggestion was to use one of the multi select examples
what did you try?
and you always can add a checkbox which says "select all detail data"

Taifun

[mustafaalbasel]

i just don't understand the concept for checking using the multi select and even if it worked, how can i make select all?

Multi_check

even the extension example is only for components not listviews

[mustafaalbasel]

Is there a way to add a checkbox and to make it connected with the listview selections?
so when i mark on the checkbox, all listview selections can be selected

[Taifun]

@mustafaalbasel

i just don't understand the concept for checking using the multi select and even if it worked, how can i make select all?

@ABG, the author of that solution might be able to help...

As always first try to understand the concept in a small example project before including it in your project

Taifun

[mustafaalbasel]

Yes you are right, we deserves trying to learn
Alrght, Hi @ABG lets show me any method or extension, so i can add a checkbox for listviews and make select all, all i want is to make the related listview2 selections to listview1 selections, same as the screenshot below,

you can also check my blocks for multiselection to fix what it needs

thanks both of you for your support

[ABG]

AI2 ListViews were not designed for keeping track of multiple selections.

That is left for the app author to do, behind the scenes, in a data base or list(s).

You can represent multiple selections in different ways, depending on how they help achieve the objectives of the app.

It is usually better to pick one method and not mix them.

1. Keep a separate list of the items that was selected. This is good for short selection lists out of a much larger list. You could supplement this with a list of items that were NOT selected.

2. Keep two parallel lists of items,
   a. A true/false value to indicate selected
   b. The item to be selected or not

What you show in one or more ListViews should just be a reflection of what you keep behind the scenes.

[mustafaalbasel]

can you show me blocks examples for your suggestion please ?

[ABG]

Multi_check

Multi-Select in AI2