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

[eoinparkinson]

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

[kartik_old]

Hi there, @eoinparkinson!

Try this :

[eoinparkinson]

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

[domhnallohanlon]

See also:

Its possible get other cell info based in one cell info?

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 used for de…

[eoinparkinson]

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.

[ozel1978]

Hi Kartik,

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

here it is my block.

[domhnallohanlon]

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!

[ozel1978]

Domhnall,

It worked. thank you so much