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?
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.”
1 Like
So does using a new sheet solve the problem?
It should, yes.
1 Like
thank you
The problem has been successfully resolved. Love it. However, it takes 3-4 seconds to update the news list. Can’t it be shortened?
1 Like
You need to share an image of your blocks and tell us how many rows in the table you are processing.
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.