# Store entire row from airtable in app var, then get cell info from there. Is this possible?

**URL:** <https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782>\
**Category:** Questions about Thunkable X\
**Tags:** airtable\
**Created:** [July 31, 2019, 1:37am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782 "2019-07-31T01:37:13Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![eoinparkinson](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/eoinparkinson/32/143769_2.png) [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)\
**Post date:** [July 31, 2019, 1:37am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/1 "2019-07-31T01:37:13Z")

</div>

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:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\
**Post date:** [July 31, 2019, 2:01am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/2 "2019-07-31T02:01:12Z")

</div>

Hi there, @eoinparkinson!

## Try this :

> ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7ea3fadeb408e81167a659bba715db93045e81ac.png)

---

<div class="post-metadata">

**Author:** ![eoinparkinson](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/eoinparkinson/32/143769_2.png) [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)\
**Post date:** [July 31, 2019, 11:41am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/3 "2019-07-31T11:41:01Z")

</div>

Bare with me while I try this out. Thank you very much.

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [July 31, 2019, 11:44am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/4 "2019-07-31T11:44:09Z")

</div>

See also:

> [@\[Solved\] Is it possible get other cell info based in one cell info?](http://community.thunkable.com/t/its-possible-get-other-cell-info-based-in-one-cell-info/162710/5):
>
> Here’s a quick explainer of my approach to this: Screen1 The first thing I do is get 30 out of the 100 names from Airtable, and display them in the ListViewer: [20] Then when one of the names in the ListViewer is clicked, the index of the clicked items is stored in this rowNumber variable [23] Screen2 On Screen2 the rowNumber variable is used to get a row of data from Airtable and once this is done all the labels are populated with the relevant data. Note that Label3 is just …

---

<div class="post-metadata">

**Author:** ![eoinparkinson](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/eoinparkinson/32/143769_2.png) [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)\
**Post date:** [July 31, 2019, 11:52am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/5 "2019-07-31T11:52:57Z")

</div>

Thanks @domhnallohanlon and @kartik_old!

I don’t usually use Airtable, I have to start somewhere though!

Kartik this solution works brilliant, thank you very much.

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [October 22, 2019, 4:12pm UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/6 "2019-10-22T16:12:25Z")

</div>

Hi Kartik,

I have tried exactly block as per provided but i got ‘undefined’ at label.

here it is my block.

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

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [October 22, 2019, 10:30pm UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/7 "2019-10-22T22:30:59Z")

</div>

Hi @ozel1978!

You should probably be setting the text of your label inside the `then do` part of your `GetRow` block. This way you know that your `app raw` variable will definitely have received a value from the spreadsheet.

thanks!

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [October 23, 2019, 2:49am UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/8 "2019-10-23T02:49:01Z")

</div>

Domhnall,

It worked. thank you so much

---

<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:00pm UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/9 "2021-12-19T12:00:26Z")

</div>

Is there any updated way for doing this @kartik_old because on Thunkable X we don’t get any of the block’s.

---

<div class="post-metadata">

**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, 12:08pm UTC](https://community.thunkable.com/t/store-entire-row-from-airtable-in-app-var-then-get-cell-info-from-there-is-this-possible/162782/10 "2024-11-08T12:08:36Z")

</div>


