How to sort data based on one of the lists

[mjssakuruppampady]

Hey …
I also have a similar function where I have to sort different lists based on a single lists. I have a csv table from which I formed different lists containing each fields. I need to sort the data based on one of the lists.
Did you find a solution to this problem? If yes, can you help me solve this? Or can you suggest me an alternative you found to solve this problem.

Thanks in advance …!!

[Taifun]

@mjssakuruppampady

I have to sort different lists based on a single lists

what about using the sqlite database?
https://docs.kodular.io/components/storage/sqlite/
you can filter or sort each column easily…

Taifun

[mjssakuruppampady]

@ Taifun Thankyou for responding and your response. The database from which I get the data table is Google Sheets. I get the csv format of each sheet and then convert them to lists. These list need to be sorted. Working with google sheets is more comfortable for me than with sql databases. I would like to solve this problem by not shifting the database now.

[Taifun]

@mjssakuruppampady

The database from which I get the data table is Google Sheets

you might want to use the Google Visualization API to filter or sort your spreadsheet as shown here App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps

Taifun

[mjssakuruppampady]

@Taifun Thankyou for sharing the extension. It works good. While searching elsewhere about this, I found another way to do the same(almost similar) to sort and filter data from google sheets. Using query language in sheets link, we can get queried output of data from sheets in required format. For eg. I was getting csv format of the full sheet and converting the csv to list in blocks by using link -->
https://docs.google.com/spreadsheets/d/{sheet link}/gviz/tq?tqx=out:csv&sheet=sheet1

Now I can get filtered data by using query language in the link and download filtered data in csv format.
eg. https://docs.google.com/spreadsheets/d/{sheet link}/gviz/tq?tq=select%20A%2C%20sum(B)%20group%20by%20A&tqx=out:csv&sheet=sheet1

Here’ the documentation I found helpful to implement this. This is an alternative to using the extension, I think…!!
https://developers.google.com/chart/interactive/docs/querylanguage

[Taifun]

@mjssakuruppampady

Thankyou for sharing the extension.

this is not an extension… this is how to do it using the web component…

@mjssakuruppampady

Now I can get filtered data by using query language in the link and download filtered data in csv format.
eg. https://docs.google.com/spreadsheets/d/{sheet link}/gviz/tq?tq=select%20A%2C%20sum(B)%20group%20by%20A&tqx=out:csv&sheet=sheet1

so what is the difference between my solution and this?
it is exactly how the example is working…

Taifun

[mjssakuruppampady]

Not much difference as I mentioned before. Both functions the same way. In addition to sorting and filtering data you can download that data as a pdf or csv or json with the link itself, which I think is useful to be used with a button. I found this bit more easy to work with. Just shared it here, so someone would find it helpful in future.