# GetAllRown in new drag&drop UI

**URL:** https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867
**Category:** Questions about Thunkable X
**Created:** [January 3, 2022, 11:06pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867 "2022-01-03T23:06:19Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![fedegarcia30hzc97a](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@fedegarcia30hzc97a](https://community.thunkable.com/u/fedegarcia30hzc97a)
#### Post date: [January 3, 2022, 11:06pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/1 "2022-01-03T23:06:19Z")

</div>

Hi

Im working with the new drag&drop UI with an application that has an Airtable connection.  
I see there is no getAllRows so i can the work on the properties of each row…insrtead we have list of values wich will just get one column or get row object wichj would need to connect X numbers of times if you need to apply cetain filters based on the value of a column value.

Am i missing somehting? With this apporach the app get very slow as i need to connect many times to the database. My airtable has 6K rows…

Thanks!!!

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [January 3, 2022, 11:28pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/2 "2022-01-03T23:28:07Z")

</div>

I think just about any approach where you try to sync all of your data to your project with 6,000 rows will be very slow.

Why do you need all of the data within the app? Can you use Airtable’s API to filter and sort as needed instead?

See this: [The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #44 by jared](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167/44)

---

<div class="post-metadata">

### 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: [January 4, 2022, 12:18am UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/3 "2022-01-04T00:18:14Z")

</div>

Do you _need_ to retrieve all the data at once? I too noticed recently that we didn’t have that block for data sources anymore _but_ most of the time we don’t need it all either.

---

<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: [January 4, 2022, 9:48am UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/4 "2022-01-04T09:48:37Z")

</div>

You could be right about the `GetAllRows` but for most of the searches, only one column is required and for that reason the `list of values` becomes a more convenient way. You do not even need to use `for each item` loop to find what you need.

See this example

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

This works much better for long lists than the old method of looping through all contents.

---

<div class="post-metadata">

### Author: ![fedegarcia30hzc97a](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@fedegarcia30hzc97a](https://community.thunkable.com/u/fedegarcia30hzc97a)
#### Post date: [January 4, 2022, 6:24pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/5 "2022-01-04T18:24:41Z")

</div>

Hi all

Correct. the new functions are usefull but i have a case where a use airtable table where i have a set of information (different columns) where i need to show information in the UI based on the value of various columns at the same time.

With the old UI i could fetch all rows at once and then play with the getProperty function wich as is done in memory is much faster.

Ive also noticed that retrieving values with the getValues functions takes more time than before…in this example im looking for the row ID based on the list loaded when i start the app and its taking 5 to 7 seconds every time…

In this step im loading the list with all the values, it takes around 20 sec to load 5K values

 ![imagen](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/7/978f7e220dd48c6ab2e2ccc48480576183ea6b66.png)

In this step im loading the information os a column based on the name column (wich is unique) and its taking around 6 sec

 ![imagen](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/608f614e91d6211e6b894ccafd5a2d10b82f4d17.png)

Are you experiencing the same?

---

<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: [January 4, 2022, 7:03pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/6 "2022-01-04T19:03:48Z")

</div>

> [@fedegarcia30hzc97a](#):
>
> it takes around 20 sec to load 5K values

Wow, 20 second is too long to wait. Your other option is to use Airtable API as previously suggested.

---

<div class="post-metadata">

### Author: ![fedegarcia30hzc97a](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@fedegarcia30hzc97a](https://community.thunkable.com/u/fedegarcia30hzc97a)
#### Post date: [January 4, 2022, 9:07pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/7 "2022-01-04T21:07:42Z")

</div>

Thanks, ill work on the API, although id first test this app on the standart UI to see wether is the implementation of the new functions or normal behaviour

Thanks for the feedbaks!

---

<div class="post-metadata">

### Author: ![fedegarcia30hzc97a](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@fedegarcia30hzc97a](https://community.thunkable.com/u/fedegarcia30hzc97a)
#### Post date: [January 5, 2022, 2:25pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/8 "2022-01-05T14:25:50Z")

</div>

Hi @muneer I tested with the API and it works incredebly well, thanks for your suggestion.

---

<div class="post-metadata">

### 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: [April 5, 2022, 2:26pm UTC](https://community.thunkable.com/t/getallrown-in-new-drag-drop-ui/1664867/9 "2022-04-05T14:26:48Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
