Hi team, as per the subject, I have a small project I am working on for myself as a learning exercise (it’s a personal recipes database, and am trying to set it up to find any matches on rows that match a certain string - ie. looking for an ingredient, etc). In the project, I have a Google Sheets da…

I did just notice when I referred back to this thread that I was using as a reference when I went for the specific row #, rather than trying to find an ID… and I noticed that I had a standard text value in there rather than an actual value block. However, I’ve updated it, and it’s still not writing…

This works for me so I think there may be a problem with your Google Sheet not being synced in Thunkable. This can happen if you change the name of a column header or add/remove columns. And no, it doesn’t matter if the row id is a text string or numeric value. [image] Can you update the value in…

Thanks for the confirmation that it SHOULD work! That’s always a good start knowing that you’re at least on the right track lol. I had a look, tried simply writing a fixed value, which didn’t work. So then I added a create row call on a different table, just to test it out - and THAT didn’t write, …

Worked around it this way - check to see if there’s an entry in the table… if there is, update it. If there isn’t, create it: [image]

Failing to write to a specific cell in a Google Sheets data source

Questions about Thunkable X

grinkingr3yr6z August 31, 2024, 4:48am 5

Oh!! I just found the answer, I think. Got a good hit on the “related topics” at the bottom this time around. No idea why it didn’t show this one up earlier lol.

From Writting to Google Sheets seems to be unreliable

Topic		Replies	Views
Writting to Google Sheets seems to be unreliable Questions about Thunkable X beginner	2	79	April 29, 2024
Simple Google Sheet - writing a row Questions about Thunkable X solved , beginner	3	537	March 18, 2022
Sample Google Sheet project? Questions about Thunkable X google , spreadsheets	11	1034	September 13, 2020
[Solved] Not updating data in stored data source local table Questions about Thunkable X	12	846	October 12, 2023
Thunkable doesn't function well with the google spreadsheet data source Questions about Thunkable X data-viewer	9	2227	September 23, 2020

Failing to write to a specific cell in a Google Sheets data source

Related topics