Hi, I am new and noob to thunkable. I am doing data processing (some calculation) in a Google sheet where I will “update” a value to it, and after processing by the sheet, I would like to “get” the value to be display in the app. So far the very first instance of these operation works fine. But no…

I made some test and what you are saying is correct. The block does not retrieve the updates. However, when I tested with this block [image] I was able to read the updates multiple times. Maybe someone from Thunkable @staff could give a better solution / explanation.

Hi @darrickloh , Welcome to the community. [image] darrickloh: Any advise will be very much appreciated. Maybe you can try Realtime DB by Google Firebase. It also works. You can store many values in it and it’s in Realtime. You can use the DataChanged and Add Listener Block to detect new valu…

Thank you. I am looking for a solution just to read one cell or value from the sheet.

You will need this [get_value] To read a single cell.

Thanks muneer. I did just that, but it works for the first time or every time the app startup but not after that when I updated to another value.

This is my test project here: https://x.thunkable.com/projects/600f6d9160d50f0011502133/9f1c88b4-7c81-4490-90e1-b6367dd7704d/designer [Screenshot 2021-01-26 092800] Appreciate any advise. Thank you again.

Working with Google Sheet

Questions about Thunkable X

darrickloh January 27, 2021, 11:11am 9

Dear Mr Muneer,

That block works! Thank you so much!

Topic		Replies	Views
How do I get up-to-date/live data from Google Sheets? Questions about Thunkable X google-sheets	9	1448	April 6, 2022
Google sheet not updating Questions about Thunkable X	13	1866	January 6, 2024
Datasource update Questions about Thunkable X beginner	6	700	November 11, 2021
Live sync with source - Google sheets Questions about Thunkable X	7	1020	July 30, 2023
Google Sheets data source doesn't update every time Issues / Bugs data-source , google-sheets	16	1805	July 23, 2023

Working with Google Sheet

Related topics