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 gettin…

[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 o…

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 recent…

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 i…

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 Sho…

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 snap…

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 s…

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	447	November 15, 2020
[Solved] Get cell value from other column Questions about Thunkable X solved , airtable	52	3668	April 27, 2021
Get Airtable Column based on condition of another column and apply to list viewer Questions about Thunkable X design , airtable	14	2036	May 27, 2020
[Solved] How to query and filter data from airtable? Questions about Thunkable X airtable	5	2807	January 8, 2021
Ayuda con Airtable Questions about Thunkable X	2	446	April 1, 2020

Get particular row information via particular text from airtable column

Related topics