# Get particular row information via particular text from airtable column **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [February 12, 2022, 3:12pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653 "2022-02-12T15:12:40Z")\ **Posts on this page:** 9\ **Page:** 2
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [February 13, 2022, 8:10pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/21 "2022-02-13T20:10:35Z")
> [@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](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/36fd7fa9feaa90c73fdecea964c891cef0469d72.png) The main block includes to fill up both lists ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/5/e5e8f635ab1e1cdf28102cc06826540ba9087659.png) When selecting any item from the `List Viewer` you will need to use the green block `index` to get the row ID. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/9/497bb85fdd24d46962f3679786ab61ff04f932c5.png) Hope that makes it clear. ---
**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\ **Post date:** [February 14, 2022, 8:11am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/22 "2022-02-14T08:11:09Z")
Its Very clear and it worked… Thank you so much for your patience and detailed explanation as always. ---
**Author:** ![Dario\_Cappello](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@Dario\_Cappello](https://community.thunkable.com/u/Dario_Cappello)\ **Post date:** [February 14, 2022, 8:26am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/23 "2022-02-14T08:26:51Z")
> [@Dario\_Cappello](#): > > filterbyformula Hello. I don’t think there is my solution at the top. Maybe I did not say it clear enough. Suppose we have such a column PROFESSIONS aerospace engineer construction engineer mechanical engineer naval engineer mechanical construction worker mechanical metal worker and I want to extract the records which contain mechanical. How should I set up filterbyformula? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [February 14, 2022, 10:45am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/24 "2022-02-14T10:45:19Z")
> [@sasi.preethag3yh](#): > > Its Very clear and it worked… I’m glad you found it helpful. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [February 14, 2022, 11:46am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/25 "2022-02-14T11:46:42Z")
> [@Dario\_Cappello](#): > > I want to extract the records which contain mechanical. The filterByFormula runs exact search and therefore you get back only what exactly matching the text you provide. You can try the `FIND` method in the `filterByFormula` to achieve what you want. Try something like this: `filterByFormula=(FIND("mechanical",{PROFESSIONS}))` You might need to adjust the text to be acceptable to Airtable expected format to have it working. ---
**Author:** ![Dario\_Cappello](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@Dario\_Cappello](https://community.thunkable.com/u/Dario_Cappello)\ **Post date:** [February 14, 2022, 2:53pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/26 "2022-02-14T14:53:06Z")
Thanks muneer, I’ll try later and update you ---
**Author:** ![Dario\_Cappello](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@Dario\_Cappello](https://community.thunkable.com/u/Dario_Cappello)\ **Post date:** [February 19, 2022, 3:31pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/27 "2022-02-19T15:31:45Z")
thanks muneer, it works great. Perfect syntax! ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [February 19, 2022, 4:39pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/28 "2022-02-19T16:39:09Z")
I’m glad it worked for you. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [May 20, 2022, 4:39pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/29 "2022-05-20T16:39:11Z")
Closed on May 20, 2022, 4:39pm UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653.md?page=1)