I need to set a unique ID has (00000001),last two digit should increase by 1
can any one suggest expression
Click through to read more…
[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 …
1 Like
Auto - sequential numbers, using Googlesheet formula - no duplicate! Tips & Tricks ?
“To get the auto-sequential number” without duplicates is one of the frequent question and ask here in the community, but there is no native and perfect solutions available for the time being. This is not a perfect solutions, and I m not strongly recommend to implement this tricks into your production app as I m not sure how it will be stable in terms of the performence, but at least, my quick test showed positive result to generate the sequential number dynamically, using Googlesheet formula. …
2 Likes