# How to get whole row with the help of first column of that row from Air table **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** airtable\ **Created:** [April 10, 2020, 5:18am UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102 "2020-04-10T05:18:35Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sakshamgoyal4031](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sakshamgoyal4031](https://community.thunkable.com/u/sakshamgoyal4031)\ **Post date:** [April 10, 2020, 5:18am UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/1 "2020-04-10T05:18:35Z")
Hello I just want to know how to get data from Airtable If we fill the data of 1st column? On the basis of 1st column I want to get whole row. So how to get it? Please help me @jared ---
**Author:** ![cttricks](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cttricks/32/93678_2.png) [@cttricks](https://community.thunkable.com/u/cttricks)\ **Post date:** [April 10, 2020, 1:42pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/2 "2020-04-10T13:42:29Z")
So call the 1st column and get the values of that column and store it in a global\_var in as a list. Row1,Row2, Row3 … ,Rown Now to call the value of Row1 simply use the get row block of airtable compoennt and set row no to the index of Row1 from the column list { In this case the index-no is 1 } ~Ct tricks ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [April 10, 2020, 1:48pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/3 "2020-04-10T13:48:05Z")
Yup. What @cttricks said, you get the values of column 1. Store values in a list “\_savedColumn” Search list for first occurrence of email or some other unique identifier, usually a row id or key value. (This is how you find the row number) get that row Save in a var “\_savedRow” (Then for example to extract info from that row) From label1 set text to (get property {columnName} of object {\_savedRow}) You’d follow this basic idea for each property you want to extract ---
**Author:** ![sakshamgoyal4031](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sakshamgoyal4031](https://community.thunkable.com/u/sakshamgoyal4031)\ **Post date:** [April 10, 2020, 1:49pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/4 "2020-04-10T13:49:44Z")
How to filter data of airtable and display on screen ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [April 10, 2020, 1:50pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/5 "2020-04-10T13:50:18Z")
See my example app I have shared you already. These blocks are in that example ---
**Author:** ![cttricks](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cttricks/32/93678_2.png) [@cttricks](https://community.thunkable.com/u/cttricks)\ **Post date:** [April 10, 2020, 1:50pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/6 "2020-04-10T13:50:50Z")
I’m not good at explaning things 😂 Thanks @jared for elaborating ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 24, 2021, 1:58pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/7 "2021-04-24T13:58:46Z")
I also want to see the blocks. How can I import a row from the table with an identifier in the first column ---
**Author:** ![jane](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jane/32/27575_2.png) [@jane](https://community.thunkable.com/u/jane)\ **Post date:** [April 27, 2021, 2:35pm UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/8 "2021-04-27T14:35:46Z")
Hi there, These blocks will allow you to get the first row which has a given value (here called `LOOKUP VALUE`) in a specified Column. As mentioned above, make sure you are working with a column with unique values - user IDs, order numbers, etc. ![Screen Shot 2021-04-27 at 3.34.15 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/2/62de24bdd46917cb9d68a18acb65b0c0c640c678.png) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 11:39am UTC](https://community.thunkable.com/t/how-to-get-whole-row-with-the-help-of-first-column-of-that-row-from-air-table/563102/9 "2024-11-08T11:39:12Z")