Hi!
I looked here for some topic for my problem, but I didn’t find it.
I’m using the “list of values in” block to get the IDs of the Google sheet rows. When checking the list through a “for”, he cannot bring these IDs (it’s as if the ID did not exist). But any other column they bring the values. Could you help me with this?
Please show a screenshot of your blocks.
It’s possible it’s related to this issue: Can't get row ID from list of values
Hello! Thanks for answering!
I had seen this thread suggested by you but I couldn’t solve my problem yet.
A print of the block follows.
This worked fine when I tested data that I entered directly into the cell. But I needed to make a change in the worksheet so that the columns are being “populated” with data from another page of the worksheet through the ARRAYFORMULA (=ARRAYFORMULA(Answers!B2:F)) function. After I made this change the IDs are no longer being captured. It’s like I lost the worksheet reference. But if I manually enter the IDs are found by the “list of values in” block.
PS.: I already deleted the project’s base in Thunkable and redid the whole process as if it were a new base instead of just doing a synchronization. yet it still doesn’t work.
If you assign the list of values block to a List Viewer (now called “Simple List”), do you see values there?
What happens if you add a Wait 0.03 seconds block to your loop?
There has been a bug for a while that prevents new values from populating the get value block. You might try a workaround which is to use the get row object block instead.
I tried to apply your suggestions, but none worked.
I pointed the list of IDs to another page in the worksheet and added some values manually, without using the ARRAYFORMULA function (without copying the data from another page). And it worked!
It implies that the problem is in the worksheet and not in the app. But I don’t know how to solve this problem yet… it’s like the line created through the ARRAYFORMULA function doesn’t generate an ID, I think.
“ID” is a reserved property in Thunkable. You shouldn’t be using it for a column title. When you add data to a data source, each row has a unique row ID.
What happened when you assigned the list of values block to a List Viewer / Simple List?
I understood. The ID I’m capturing so I can read the data from the column headers, instead of reading it column by column.
As for the simple list, no data appeared, it remains blank.
Do you have a column titled “ID”? If so, that’s the problem. If not, then you should see the list of values in a List Viewer / Simple List. Can you post a screenshot of the blocks you used to check that?
No, it doesn’t have an ID column created by me. The “column” ID only appears as an available option when I’m going to do a list query using the “list of values in” block (print 1). In the “get value from” block, no ID appears, only the columns I created.
Through a List Viewer, as the parameters are defined in the list settings, I can list whatever I want, because I already inform the column. But in the simple list, which I need to create a loop to go through the list and capture the data through the ID, it doesn’t work. A print of the blocks follows (2).
Print 1
Print 2
You’re doing a lot in a loop that fires instantly over and over again. I wouldn’t expect that to work properly.
It’s like if I shouted at you “go run a mile!” every 10 seconds. There’s no way you could do that.
Can you share a link to your project?
This is not true. “ID” is a reserved column name in Thunkable. It already exists when you sync a data source. So they should not create a column called “ID”.
I dont mean the ID that consists of Letters. I mean an ID that can sort the values (Usually numbers)
I don’t understand, sorry.
The ID that is generated by Thunkable is not a number but a long text of characters that’s why if someone wants to sort his rows according to the that ID then he cannot. He should create an ID (A number) for each row.
Please correct me if I am wrong.
Okay, I understand what you are saying now. Yes, you would need different values to sort. But that new column should not be called “ID”. I think we are in agreement. 
Hello! Thanks for replying and sorry for my delay.
Well, I ended up redoing part of the project. Instead of using the automatic ID, I decided to use a unique value that I was already seeing in the spreadsheet. So, instead of using the block to read the list with ID, now I read the list with the other value.
I took advantage and identified a serious problem of loss of performance when reading data from the worksheet. With few records I have a relatively quick response. When it reaches a large number of records (I already have more than 500), it becomes impractical to use the direct search in the spreadsheet. So I made a change by creating a temporary local database and also switched to using Firebase for other things.
I couldn’t solve the ID problem I reported at the beginning, but I solved my problem by changing the search strategy.
Thanks a lot for helping!
Awesome! Sounds like a lot of debugging and trial and error lead to some successes. That’s been my experience using Thunkable (and I’m sure it’s not limited to Thunakble as a no/low-coding tool).
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
