It come from row number in table in google sheet. !!!
The _RowNumber value reflects the spreadsheet row number. Spreadsheet row number 1 is the header row, which is not a data row; therefore, there is no row in your table with a _RowNumber of 1.
Generally speaking, using _RowNumber is not a good idea. Its value can change, and there could be gaps between sequential numbers. You’d be better off adding your own column for numbering.
3 Likes
I will add new new column type number .
How to auto increment number for every time to aad new row ?
1 Like
See this post:
[Serial Numbers, If You Must](https://community.appsheet.com/t/serial-numbers-if-you-must/19325) Tips & Tricks ?
Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …