How I can Get Filtered Rows

Creator Lounge
1

Hello, community

I have google table like a data base. And I need recieve list of filtered records for one condition like a equal in one of cell. This records need show in list on screen. How it work? I use this block and I’m can not solve this task.

image
image978×194 16.7 KB

google table

image
image785×242 7.46 KB

Regards for eneryone

2

Are you wanting to get one row or multiple rows that match? Do you need a single cell value as a result or a full row (or multiple rows)? In your example, the next row matches as well. If you need multiple, then you need to do a loop to find all matching cells.

This is easier to do with Airtable’s filterByFormula but if you must use Google Sheets, then that’s not an option.

1 Like
3

I need multiple rows that match / multiple rows…

Thank you for you help, tatiang

4

This will loop through a single column looking for a matching string. When the string is found, it will add that row to a list. When the search loop is complete, it will display the value of the first matching row’s “Fruit” column value.

image
image1604×926 106 KB

1 Like
5

How I can solved my task with Airtable’s filterByFormula? Please, show example for recive full row from data-base (airTable) and multiple rows.

6

Tatiang,

This block not sotrted, but show all rows from data base. Do you see mistake…?
And one more. If I use NOT EQVAL - result is same…

image
image1225×543 59.5 KB

Regards

7

Here is an example of how to use filterByFormula: The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #22 by jared

I’m not sure why your blocks are not working but I can tell you that you should avoid using a [gear list] block unless you are initializing or setting a variable. So where you have in list [gear list [app variable Nomer_z] get #1, you need to remove that block.

1 Like