# Data Viewer List Refresh **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [December 16, 2022, 8:41pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506 "2022-12-16T20:41:15Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 16, 2022, 8:41pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/1 "2022-12-16T20:41:15Z")
Hi Thunkers. I would like to know about these two possible blocks ![dvl refresh](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/2/e236889ef0aac456d4aebb16f11f3af3fb1612c0.png) and ![Any component DVL refresh](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e3cd641165c9e105edcd4a0a1ca43466a10dd5cf.png) . I’m trying to overpass the 100 rows we get when calling our data from Google sheets… Or is there a better way to do that? Thanks ---
**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:** [December 16, 2022, 10:45pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/2 "2022-12-16T22:45:34Z")
The refresh data block just syncs the displayed data to the current data in the data source. It has nothing to do with how many rows of data there are or which rows get displayed. You may need to load rows 1-100 and then rows 101-200 to replace that, etc. I imagine you would do that with a Google Apps script or a loop through those rows in Thunkable. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 17, 2022, 11:39am UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/3 "2022-12-17T11:39:02Z")
> [@tatiang](#): > > I imagine you would do that with a Google Apps script or a loop through those rows in Thunkable. Hi, Tatiang, Thanks for the information. I just don’t know how to to that (101-200, 201-300, 301-400… because I’m working with vocabulary, and that means thousands of words) and I don’t find any example to loop those rows in thunkable either… I thought perhaps the block in Any Component should be enought. In fact, I used it, and nothing happened, I erased it, and now one of my DVL proyects is able to “read” all of the elements in the list, and I can’t figure out why… I have trried some workarounds you suggested, and nothing If you had a working model, it would be great. Thank you ---
**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:** [December 17, 2022, 5:03pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/4 "2022-12-17T17:03:14Z")
I don’t know how to do it either but if you Google _Google apps script get rows_, the first result looks quite promising. In Thunkable, you would do something like this: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/2/d221ebe9542da6c05ac04f65b97bbca1ff58136b.png) Often these kinds of loops are too fast to allow for the creation of the row each iteration so it can help to put a Wait 0 seconds (which is a tiny delay!) inside the create row block and/or right after it. By the way, if you only need **one** column of data from Google Sheets, there might be a much easier way to do this using the `list of values` block. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 17, 2022, 10:32pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/5 "2022-12-17T22:32:35Z")
@tatiang Thank you so very much for your blocks. I’ll try them at once, and I will let you know about the results. Well, I need several columns of data from google sheets, to use them in multiple choice tests, for instance. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 17, 2022, 11:20pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/6 "2022-12-17T23:20:22Z")
> [@tatiang](#): > > _Google apps script get rows_ @tatiang Hi, I have been trying to use your example according to my blocks, but as I’m not really sure, and I don’t get the results I need, I have to ask you to have a look at my blocks, just to see what should be the Name of my app or stored variable I have to use. Or the order of those elements ![Tatiang2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fd1f56c20cc8b4378ffbfaa0faf4ce97c347b805.png) ![Tatiang4](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/0/203d08af43fab164841deab0bbed3c3904096bb3.png) ![Tatiang5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c8ad19386ecd1f44b799caaa66d9deb378a4f45c.png) Thanks ---
**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:** [December 18, 2022, 12:10am UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/7 "2022-12-18T00:10:31Z")
I’m so sorry! There was an important detail missing from the blocks I shared. 😬 When you loop through the rows of your Google Sheet such as 101 to 200, you should be creating rows **in a different data source**. For that, I would use a local data source for speed although you could use another Google Sheet if you wanted to. And then use the second data source for displaying values in the app. The first/original data source is only used as the master database but isn’t referred to any other time. And you would also delete all rows from the second data source, not the first/original. ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 18, 2022, 4:28pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/8 "2022-12-18T16:28:54Z")
@tatiang Well, I have a second local Data source, called Current Term, but it is only to take the data four by four to show it in the Data Viewer List. You are the expert, but I can’t see it when you say “to create rows in a different data source. For that, I would use a local data source for speed although you could use another Google Sheet if you wanted to”… If I create another google sheet, wouldn’t I have the same limitation every 100s to retrieve the data?. And, not being an expert, as it is my case, how would I do that? Anyway, I think that all these details, very important details, should be perfectly explained in the documentation and with some examples… I imagine many people will have files with more than 100 entries… just to have the same problems I’m having, and needing the same explanations I need to solve this… all of my projects are unfinished because I can’t solve this very same problem, and not knowing how to do things Any way, thank you very much ---
**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:** [December 19, 2022, 6:35am UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/9 "2022-12-19T06:35:02Z")
The idea is to display 100 entries at a time but allow the user to cycle through more sets of 100. The purpose of a second data source is to keep the original pristine with thousands of rows and with the second data source to continually delete all rows & populate it with 100 rows. I would argue that most projects don’t require displaying hundreds of items in a list at one time. Is there a reason you need to display thousands of words at once to the user? What does your user interface look like? ---
**Author:** ![similar2similar](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@similar2similar](https://community.thunkable.com/u/similar2similar)\ **Post date:** [December 19, 2022, 1:35pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/10 "2022-12-19T13:35:10Z")
Hi, @tatiang Thanks for your answers. I’m thinking I’m going to have to abandon the DVL method and come back to the buttons one, to show words 4 by 4 in my multiple choice questions, because they don’t have these problems. In one of my interfaces, you can see a list viewer with all of the words you need to learn, no limit, so I think I need the same in the other interface. If I didn’t do it this way, I imagine ((as I don’t know how to program it) I should have to make a menu with 18 choices (for instance, one of my vocabulary lists is about the verbs that are similar between English and Spanish…(yes, more or less 1800 verbs), and there are a total of 18000 similar words to group one way or another… So, It’s a pity but I’ll have to come back to my very first steps in this thunkable world. ![Tatiang User Interface1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c1fd5ee8fa5e74c26e8626956680f05dfb17007d.png) ![Tatiang User Interface2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/9/a93ee10f0787b9745933a87d825070dba9ca4fac.png) ---
**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:** [March 19, 2023, 1:35pm UTC](https://community.thunkable.com/t/data-viewer-list-refresh/2182506/11 "2023-03-19T13:35:44Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.