# Getting row data, and saving it in different components

**URL:** <https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175>\
**Category:** Questions about Thunkable X\
**Tags:** database\
**Created:** [December 19, 2021, 12:02pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175 "2021-12-19T12:02:36Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 12:02pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/1 "2021-12-19T12:02:36Z")

</div>

Is there any updated way for doing this blocks!! Because I searched for this blocks and can’t find any of them.

> [@Store entire row from airtable in app var, then get cell info from there. Is this possible?](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782):
>
> There may be a topic for this already, but I have searched and I cannot find it! I am pulling a lot of data from a specific row in airtable (this row number can change depending on what the user selects) To save my app doing 10 requests or so for each different cell in that row, can I simply call a get entire row then pick each specific piece of data from that row which is now locally saved in a variable or something? It is just text, no photos. It would speed my entire app up. Many thanks

---

<div class="post-metadata">

**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:** [December 19, 2021, 12:14pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/2 "2021-12-19T12:14:05Z")

</div>

You already posted the question in the same thread. There is no advantage in spamming the community with the same question.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 12:25pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/3 "2021-12-19T12:25:50Z")

</div>

Sorry, if it was spamming, but I wanted a better reach for solution, that’s why re-shared this.

---

<div class="post-metadata">

**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:** [December 19, 2021, 12:27pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/4 "2021-12-19T12:27:54Z")

</div>

A better way is to explain your situation clearly showing what you expect and what you are getting from your blocks and you will get a better answer from referring to a **2 year old** post.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 12:35pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/5 "2021-12-19T12:35:26Z")

</div>

What I want is, when a particular item is selected from list viewer (obviously filled from data base) I want that particular row data, and store it in different text box.  
For e.g., if one value matches, than other field should be automatically filled with the row data having that value.  
I have four columns:- name, address, contact number and sr no.  
So name column is used in list view, as a particular name is selected all other values of that “name” i.e., address, contact and sr no should be stored in there respective text boxes.

---

<div class="post-metadata">

**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:** [December 19, 2021, 12:42pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/6 "2021-12-19T12:42:50Z")

</div>

When you select the name from the list viewer, the block has a green block called `index`. You this block as the row ID in this block to get the entire row  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec61bc294ef2f268e13e907da34bee137f73e389.png)

You then need to use  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/b/3bf1a76e26475f155f6e8b8b67b16c5b97bd1cab.png)  
to retrieve the values of other columns from the object you just obtained.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 12:44pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/7 "2021-12-19T12:44:44Z")

</div>

Where do I put this get rowobject block?

---

<div class="post-metadata">

**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:** [December 19, 2021, 1:01pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/8 "2021-12-19T13:01:04Z")

</div>

See this demo

[https://x.thunkable.com/projectPage/61bf29d1d038ef0011f0aa1e](https://x.thunkable.com/projectPage/61bf29d1d038ef0011f0aa1e)

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 2:00pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/9 "2021-12-19T14:00:34Z")

</div>

Sir, it’s giving me another row. in the below screen when i select “ashok” it should return ashok in Client textbox and 24afm in GSTIN Textbox. But it returns me row number 1 of database i.e., jayank and “-”

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/a/babd88489f3dce32a8081ecb9c1b287f4874adf6.png)

Data Base:-

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/c/cc636c8e24b7d87cbb709d6fa02e8b58a69b0fd0.png)

---

<div class="post-metadata">

**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:** [December 19, 2021, 2:05pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/10 "2021-12-19T14:05:03Z")

</div>

Show me your blocks. I wouldn’t know where you went wrong without seeing the blocks screen.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 2:12pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/11 "2021-12-19T14:12:09Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/f/9f42773ec5a8ebe8b06ca0723e1bd37e48db6861.jpeg)

---

<div class="post-metadata">

**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:** [December 19, 2021, 2:59pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/12 "2021-12-19T14:59:19Z")

</div>

You have not followed my demo.

The procedure works based on the **index** of the `List Viewer` should correspond to the run number in the database and this only happens when the `List Viewer` contains the full list of the specified column in the database.

You changed this and made the `List Viewer` shows a list which is a result of some **search** function which gives a subset of what’s in the database and therefore the **index** will lead to a wrong database row.

Hope this is clear.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 3:14pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/13 "2021-12-19T15:14:32Z")

</div>

Yes,sir! I see,You’re right! So how should I do. Should I make a temporary list for all columns and set it accordingly or there’s some other way around using the method you showed in demo?

---

<div class="post-metadata">

**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:** [December 19, 2021, 3:24pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/14 "2021-12-19T15:24:46Z")

</div>

It all depends on what specific use case you have. I cannot tell you if I don’t know what you are after just like when I made the demo I made it based on the full list in the database but you are using it based on a short list which is a different use case.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 3:41pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/15 "2021-12-19T15:41:54Z")

</div>

So sir, as I type into client name box, it searches the database, if found than that particular row should be filled with data. If not than let user enter data manually.

---

<div class="post-metadata">

**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:** [December 19, 2021, 3:46pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/16 "2021-12-19T15:46:31Z")

</div>

You should find a different way from the demo I showed you. For such cases, I would use a `Data Viewer List` not a `List Viewer`.

See this demo  
[https://x.thunkable.com/projectPage/5fb9fb1dbfeb240011084d78](https://x.thunkable.com/projectPage/5fb9fb1dbfeb240011084d78)

**[Edit]**  
I have to say this is my way of thinking. This is by no means, the only way. You can still do it with a `List Viewer` in a different way.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 4:23pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/17 "2021-12-19T16:23:11Z")

</div>

I’m sorry to say sir, but I didn’t get your demo sir.

---

<div class="post-metadata">

**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:** [December 19, 2021, 4:37pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/18 "2021-12-19T16:37:51Z")

</div>

I’m sorry too for not being of help.

---

<div class="post-metadata">

**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\
**Post date:** [December 19, 2021, 4:51pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/19 "2021-12-19T16:51:37Z")

</div>

Sir! You’re my only hope here.

---

<div class="post-metadata">

**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:** [December 19, 2021, 5:25pm UTC](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175/20 "2021-12-19T17:25:01Z")

</div>

I’ll prepare a different deo tomorrow to see if it fits you.

Check this  
[https://x.thunkable.com/projectPage/61bf29d1d038ef0011f0aa1e](https://x.thunkable.com/projectPage/61bf29d1d038ef0011f0aa1e)

[Next page](https://community.thunkable.com/t/getting-row-data-and-saving-it-in-different-components/1657175.md?page=2)
