# RowID dont work with list getID
**URL:** https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700
**Category:** Questions about Thunkable X
**Created:** [June 14, 2023, 7:09pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700 "2023-06-14T19:09:49Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 14, 2023, 7:09pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/1 "2023-06-14T19:09:49Z")
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?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 14, 2023, 7:47pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/2 "2023-06-14T19:47:29Z")
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](https://community.thunkable.com/t/cant-get-row-id-from-list-of-values/2458350)
---
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 15, 2023, 2:53pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/3 "2023-06-15T14:53:16Z")
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.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 15, 2023, 3:12pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/4 "2023-06-15T15:12:29Z")
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.
---
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 15, 2023, 5:43pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/5 "2023-06-15T17:43:53Z")
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.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 15, 2023, 5:54pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/6 "2023-06-15T17:54:40Z")
“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?
---
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 15, 2023, 6:22pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/7 "2023-06-15T18:22:21Z")
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.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 15, 2023, 7:31pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/8 "2023-06-15T19:31:38Z")
> [@leonardo.cdaraujo](#):
>
> 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?
---
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 16, 2023, 4:00pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/9 "2023-06-16T16:00:30Z")
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
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 16, 2023, 4:36pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/10 "2023-06-16T16:36:10Z")
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?
---
### Author:  [@Hayder](https://community.thunkable.com/u/Hayder)
#### Post date: [June 16, 2023, 5:40pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/11 "2023-06-16T17:40:10Z")
> [@leonardo.cdaraujo](#):
>
> it doesn’t have an ID column
1. Do not count on it.
2. You must create your ID column
Note: Update Thunkable live app. If there is an update and you use the old one then you face some bugs and issues that actually do not exist. Just CHECK if there is any UPDATE in Google Store.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 16, 2023, 6:12pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/12 "2023-06-16T18:12:25Z")
> [@Hayder](#):
>
> - You must create your ID column
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”.
---
### Author:  [@Hayder](https://community.thunkable.com/u/Hayder)
#### Post date: [June 16, 2023, 6:21pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/13 "2023-06-16T18:21:39Z")
> [@tatiang](#):
>
> 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)
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 16, 2023, 6:32pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/14 "2023-06-16T18:32:12Z")
I don’t understand, sorry.
---
### Author:  [@Hayder](https://community.thunkable.com/u/Hayder)
#### Post date: [June 16, 2023, 6:43pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/15 "2023-06-16T18:43:09Z")
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.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 16, 2023, 7:22pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/16 "2023-06-16T19:22:17Z")
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. 🙂
---
### Author:  [@leonardo.cdaraujo](https://community.thunkable.com/u/leonardo.cdaraujo)
#### Post date: [June 20, 2023, 5:30pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/17 "2023-06-20T17:30:13Z")
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!
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [June 20, 2023, 7:23pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/18 "2023-06-20T19:23:06Z")
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).
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [September 18, 2023, 7:23pm UTC](https://community.thunkable.com/t/rowid-dont-work-with-list-getid/2466700/19 "2023-09-18T19:23:20Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.