Hi. In the app im making for my department, there is a column where we have to use running number to assign certificate number. So in the column I put an expression:
CONCATENATE ("AA/", YEAR(TODAY()), "/", (MAX (Registration [CofR no]) + 1))
In return: I get something like "AA/2022/1" as certificate number. My question is how can I get AA/2022/001 instead of AA/2022/1?
Please try
CONCATENATE ("AA/", YEAR(TODAY()), "/", RIGHT("000"&(MAX (Registration [CofR no]) + 1) ,3 ))
Please note that sequential numbers are very much error prone in multi user and offline app operations.
Sequential keys - AppSheet Help
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |