How to shorten code for an Airtable filter

[aarav-work]

Hello again Thunkers

Today I read a amazing Post

[Solved] How to Filter data from Airtable

I was able to get the search functionality to work in my home screen to search on specific titles. I am now trying to do similar functionality on a profile screen that would display only the current user’s posts (so the ones with the user’s email in the email field). I’m using the same idea of generating lists for the Key, email and title column. And then filtering through the email list to only use the ones that have the user’s email. I don’t have error handling to it freezes. I know it’s retr…

So I thought This is a amazing idea

Is there anyway where the code could be shorter, or you could give me the final code?

@domhnallohanlon pls can you try to give the answer.

[muneer]

Check this
https://x.thunkable.com/projectPage/5fb9fb1dbfeb240011084d78

When you select a category, the code will filter the table and show the filtered results in the second list.

[aarav-work]

Thanks @muneer

I did not understand the part below, where is SelectedCat:

this block was inside the Data viewer list clicked event.

[muneer]

Basically the DVL (Data Viewer List) lacks a filter criteria and therefore it will always display all the records in the table so as a workaround you will connect the DVL with a temporary table that you will clear all data in this table and fill it with the required data according to the user selection. This is the reason behind deleting all rows in that table.

[aarav-work]

thanks again @muneer

I went ahead and I came tot his block, can you explain it?

and how it becomes a row id?

[muneer]

Once you have cleared your temporary table successfully, you know want to populate it with the selected rows from your main table.

First retrieve the column from the main table that contains the row IDs for all rows. This column is created automatically by Airtable.

This gives us a list of all unique IDs for the main table.

Now you need to loop through the records of the main table and check if the row meets your criteria.

Here we created a loop to take each rowID from the list and assign it to variable j then retrieve the information in that row using the get block and check if this row satisfies the condition with the if condition if it satisfies then we go ahead and append this row to the temporary table (SelectedCat in this case).

In the end of the loop you will get your temporary table containing only the required rows from the main table.

Hope this makes it clear.

[muneer]

This is another example using free text search

https://x.thunkable.com/projectPage/600c35d2f153060012143dc8

[aarav-work]

thanks