Hi, I am trying to display row information of particular text in column . Ex: Column Named Skills has Garden Cleaning, Dusting, Fan Cleaning, Balcony Cleaning and so on… I want the row details of Dusting alone. If I have 2 entries for Dusting means then I should see only those 2 row details getting displayed in the listviewer. Sharing the blocks: [image] Also sharing the airtable snapshot: [image] Your input is highly appreciable…

[image] sasi.preethag3yh: After selecting the items in the Listviewer, I have to see the all the details of that selection. You will need to apply a technique rather than a specific function or block. When you get the records in the green block, it starts with records, then there is a list of objects which represents the rows in the table and each object start with a property called id. This property has the record unique number to refer to it later. So you will need to create another list and add the id to that list whenever you add a record in your list that you show to the user. [image] The main block includes to fill up both lists [image] When selecting any item from the List Viewer you will need to use the green block index to get the row ID. [image] Hope that makes it clear.

You can use the Airtable API to filterByFormula and return only results where Skills=“Dusting”. [image] The AirTable API (a more efficient way to integrate AirTable with Thunkable) Tutorials and DIY Guides I’ve had the pleasure of working on a few AirTable projects recently. One thing I’ve learned is doing stuff like this is inefficient once you start to get a lot of data. [image] You should try to limit how much data you call and the number of API calls. To update a record, you shouldn’t get all rows, loop through all rows until you find the row you need to update, then update that row. With the AirTable API you can use things like filterByFormula to query the data in one call to reduce the d…

The code you shared should not work. The green column block is actually a list. You will need to loop through this list and when you see the word “Dusting” then take the row number and use the RetRow block to view other info. You used the list block contain which should return True or False which is not a row number. Again, your are getting the row to read the value of column “Skills” which you already have from previous call of GetColumn block so why the extra steps.

If you do want to try using the API, I’m currently trying to set up filtering and multi-sorting of Airtable data. It seems to be working pretty well. Here, I’m filtering by a specific value in the Homeroom column and then sorting by Last Name then First Name in ascending (“asc”) order: [Screen Shot 2022-02-12 at 7.47.10 PM] Note that the Authorization field has the string "Bearer " with a space at the end.

It’s very Interesting. Thank you for highlighting this feature. It worked too but not all. Row creation is a cake walk. But displaying the row as per the condition is right but not right because I guess some correction to be done in the coding. Sharing the blocks. [image] sharing airtable snapshot: [image] output as per the below screenshots: [image] What is missing in the code to display only Dusting row info?

Will try Muneer and update whether its a success or not.

Your filterByFormula field is correct. But the “records” property is a list of records. It’s not a list of text strings which is what the List Viewer’s text items requires. Once you get the records lists, you have to then parse it for specific properties such as Name, Age, etc.

Try this demo project https://x.thunkable.com/projectPage/6182dddab8ae1a001142ac60 It will help you to see the same issue resolved but from another angle.

Ok… I tried it. Sharing my output: [image] Also my blocks [image] Wanted to know why just one entry is appearing? also how I can make listviewer to display as one whole text. Kindly assist.

[image] sasi.preethag3yh: how I can make listviewer to display as one whole text. The List Viewer expects a list not a single string. The variable app variable Name is not a list. For extracting data from the Airtable, let me explain with an example. I have this table [image] I want to show all the User IDs in a list using API, this is how you do it. You already know how to get the rows using the API so I will show you how to extract records from the Response green block. [image] These are variables that I use in my code. One is a list and another to hold the response of the API. [image] This is a sample output [image]

There you go… Got it now. Thank you so much for your detailed explanations along with the sample data with blocks. Sharing my corrected blocks. [image] Output as it displays as per the filter condition Dusting [image] Thank you so much. I am trying the other one which you shared .

Get particular row information via particular text from airtable column

Questions about Thunkable X

tatiang February 12, 2022, 3:35pm 2

You can use the Airtable API to filterByFormula and return only results where Skills=“Dusting”.

Topic		Replies	Views
Search data from Airtable - the come back Questions about Thunkable X	4	487	November 15, 2020
[Solved] Get cell value from other column Questions about Thunkable X solved , airtable	52	3971	April 27, 2021
Get Airtable Column based on condition of another column and apply to list viewer Questions about Thunkable X design , airtable	14	2099	May 27, 2020
[Solved] How to query and filter data from airtable? Questions about Thunkable X airtable	5	2858	January 8, 2021
Ayuda con Airtable Questions about Thunkable X	2	456	April 1, 2020

Get particular row information via particular text from airtable column

Related topics