How to sort lists of data taken from Google Sheets, and grouped as objects

Questions about Thunkable
, ,
1

Hi all. Thanks in advance for your help with this.

I have recreated an issue I am facing with my app project here: https://x.thunkable.com/copy/cf38b1d827349d69f0475d5a5c218a4e

Task: Using the data in google sheets, have the BestToWorst button fill each of the 9 labels with the correct Country, Vegetable and Rating ranked in order from the highest to the lowest without. Have the WorstToBest button do the same but with the top row of labels reflecting the lowest ranked item, the second row reflecting the second lowest and so on. All of this needs to be achieved without applying any filters/sorting to the google sheet itself.

Please share screenshots of your blocks and a brief explanation.

Ideally this would make use of the “get list” and “create object” blocks, but if you have any other ideas for how this can be done simply and quickly with larger databases, I would be keen to hear them also!

Screenshots below, let me know if you have any questions.

Screenshot3
Screenshot3551×382 17.5 KB

Screenshot2
Screenshot2305×552 13.3 KB

Screenshot1
Screenshot1356×561 14.5 KB

2

Actually, I think I may have solved it with the below blocks. Let me know if there is a more efficient/quicker/simpler method than the below:

Screenshot4
Screenshot41028×797 117 KB

3

Hi @grant.mccallum
Your blocks look great.
An alternative solution could be to sort the data source: https://docs.thunkable.com/getting-started/data-sources#sort