Filtering Data from a Spreadsheet

Questions about Thunkable
1

You can filter spreadsheet data in Thunkable, just not with a SQL “Select * from Table where column=‘abc’.”

This tutorial shows how.

Process: set up a second spreadsheet. Place the data from the first spreadsheet into list variables. Loop through the lists, use an ‘if’ to filter, and add the data as a row in second sheet if it fits criteria. Map your DataViewerList/Grid to the second sheet with the filtered data. You can also use this scheme to display data in reverse order.

1 Like
2

Have you tried this?

3

Hi and thanks for the sample, @muneer.

It looks like with Thunkable, currently, you can filter in the following ways:

  1. Google sheets formulas (Muneer’s example)
  2. Using Thunk code (loop, if) to copy some rows from original sheet to “filtered sheet” (my example)

Of course it would be great if Thunkable adds the capability to specify “Where” clause to fill DataViewerList/Grid

4 Likes
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.