# I need help with the database list **URL:** https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646 **Category:** Questions about Thunkable X **Created:** [March 6, 2022, 12:39pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646 "2022-03-06T12:39:02Z") **Posts on this page:** 9 **Page:** 3
### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang) #### Post date: [March 9, 2022, 12:46am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/41 "2022-03-09T00:46:16Z")
You need to show your blocks. Just seeing the result doesn’t allow us to help you fix this. Does that spreadsheet have 400+ rows of data in any other column? ---
### Author: ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st) #### Post date: [March 9, 2022, 5:30am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/42 "2022-03-09T05:30:58Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/b/2b584f69b8308fdf6b9230f82597d7eb6a13d889.png) The code was written like this: Why not in order? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/a/da4094b23e8ba90e71532d63264a55973b3417ff.png) ---
### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang) #### Post date: [March 9, 2022, 6:09am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/43 "2022-03-09T06:09:22Z")
The code isn’t working because what @muneer suggested will only work if the database is empty when you start. Because then when the first row is created, it will set the value to 1 and when the second row is created, it will set the value to 2. But if you already have 479 rows in the table, then that same set of blocks is going to set the value to 480. If you want the numbers to start over at 1, then you can’t use the “number of rows” block. Instead, set a stored variable to 0 and before you create a row, change the stored variable by 1. Then, use the stored variable as the “code value.” ---
### Author: ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st) #### Post date: [March 9, 2022, 6:11am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/44 "2022-03-09T06:11:26Z")
So does using a new sheet solve the problem? ---
### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang) #### Post date: [March 9, 2022, 6:11am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/45 "2022-03-09T06:11:35Z")
It should, yes. ---
### Author: ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st) #### Post date: [March 9, 2022, 7:34am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/46 "2022-03-09T07:34:13Z")
thank you ---
### Author: ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st) #### Post date: [March 9, 2022, 7:38am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/47 "2022-03-09T07:38:32Z")
The problem has been successfully resolved. Love it. However, it takes 3-4 seconds to update the news list. Can’t it be shortened? ---
### 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: [March 9, 2022, 10:30am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/48 "2022-03-09T10:30:54Z")
You need to share an image of your blocks and tell us how many rows in the table you are processing. ---
### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system) #### Post date: [June 7, 2022, 10:30am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/49 "2022-06-07T10:30:57Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646.md?page=2)