# Refresh Google Sheet Data Source while the app is open **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [May 13, 2021, 2:35am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783 "2021-05-13T02:35:43Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![3576164d90bd4c](https://avatars.discourse-cdn.com/v4/letter/3/58956e/32.png) [@3576164d90bd4c](https://community.thunkable.com/u/3576164d90bd4c)\ **Post date:** [May 13, 2021, 2:35am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/1 "2021-05-13T02:35:43Z")
Hi, I have a problem that when I use data from a data source (google sheet) without displaying through the data viewer, the data will not update when data change occurs. The app must be closed and then restarted for updates. What can I do? Thank you ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [May 13, 2021, 2:49am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/2 "2021-05-13T02:49:17Z")
Can you show your blocks? What are you doing that you expect the values to update? ---
**Author:** ![3576164d90bd4c](https://avatars.discourse-cdn.com/v4/letter/3/58956e/32.png) [@3576164d90bd4c](https://community.thunkable.com/u/3576164d90bd4c)\ **Post date:** [May 13, 2021, 3:18am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/3 "2021-05-13T03:18:17Z")
I still can’t create a block, I want to do it: loop data from the data source to filter and store it in the local data source to display in the data viewer. ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [May 13, 2021, 10:18am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/4 "2021-05-13T10:18:06Z")
> [@3576164d90bd4c](#): > > I still can’t create a block, If you’ll show what you’ve tried, we’ll help you debug it. 🙂 ---
**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:** [May 13, 2021, 11:20am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/5 "2021-05-13T11:20:23Z")
This issue was reported to Thunkable team and they are working in a fix. See this post > [@Data Sources: List Of Values from \[Column\] block does not update during app runtime](https://community.thunkable.com/t/data-sources-list-of-values-from-column-block-does-not-update-during-app-runtime/1257205): > > I am been searching around but not found best solution. i am using data source and it connect to airtable. after do operation such as edit, update or delete and it reflected to airtable but not in apps it self. it remain like keeping cache for it. i have to exit from app and login again and then only reflected. any way to reload data sources or refresh the screen? my component is using list viewer, text and label. ---
**Author:** ![garvitkohli755equjoe](https://avatars.discourse-cdn.com/v4/letter/g/a9a28c/32.png) [@garvitkohli755equjoe](https://community.thunkable.com/u/garvitkohli755equjoe)\ **Post date:** [May 13, 2021, 11:24am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/6 "2021-05-13T11:24:10Z")
hey muneer can you solve my problem ?? please its urgent ---
**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:** [May 13, 2021, 11:27am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/7 "2021-05-13T11:27:07Z")
We are all waiting to get a fix from the development team. However, I made few attempts and saw that if you use “RetRow” and read the columns in the “row” you will get updated contents. You can try this is you cannot wait for the fix from Thunkable. ---
**Author:** ![garvitkohli755equjoe](https://avatars.discourse-cdn.com/v4/letter/g/a9a28c/32.png) [@garvitkohli755equjoe](https://community.thunkable.com/u/garvitkohli755equjoe)\ **Post date:** [May 13, 2021, 11:34am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/8 "2021-05-13T11:34:59Z")
HEY Muneer I WANT TO KNOW HOW CAN WE MAKE A CODE FOR MY COMPANY FOR EG THERE IS A COMPANY NAMED XYZ WHICH DELIVERS GROCERIES ONLINE. A CUSTOMER PLACES AN ORDER ON THE APP SO HOW WILL THE PERSON AT THE STORE KNOW THAT WHAT TO DELIVER AND TO WHOM? Please answer very urgent ---
**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:** [May 13, 2021, 11:41am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/9 "2021-05-13T11:41:25Z")
> [@How to make a app that can order online things like amazon?](https://community.thunkable.com/t/how-to-make-a-app-that-can-order-online-things-like-amazon/1280626/2): > > When you add a new company or a new shop in your app, assign a random code to it, then use this code for any order made by the customers. [image] This will generate a code between 2000 and 9000 randomly and you can assign this code to the company in your spreadsheet. ---
**Author:** ![3576164d90bd4c](https://avatars.discourse-cdn.com/v4/letter/3/58956e/32.png) [@3576164d90bd4c](https://community.thunkable.com/u/3576164d90bd4c)\ **Post date:** [May 15, 2021, 6:57am UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/10 "2021-05-15T06:57:40Z")
@muneer I have seen the problem report. I’m looking forward to a solution to the problem. If it’s not too much of a hassle, I’d like to ask @muneer to explain the RetRow method. In case it might solve my problem @catsarisky @muneer thank you 🙂 ---
**Author:** ![daniel.larry](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@daniel.larry](https://community.thunkable.com/u/daniel.larry)\ **Post date:** [October 25, 2021, 12:38pm UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/11 "2021-10-25T12:38:29Z")
please @muneer can you clarify on the RetRow please? ---
**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:** [October 25, 2021, 1:30pm UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/12 "2021-10-25T13:30:57Z")
There seems to be a problem with the `Get value` block taking the values from cached source but the `Get row object` seems to have the updated values ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/0/408f5df8e00b00dc99bd789cf9f7e03b83c46756.png) Using this method you will get all columns then you need to use the object properties to retrieve the required column. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a0121b2e84f9f74837a794a8aa5fbca4b69cb21a.png) ---
**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, 1:22pm UTC](https://community.thunkable.com/t/refresh-google-sheet-data-source-while-the-app-is-open/1279783/13 "2024-11-08T13:22:29Z")