000, 001,003

[snerdya]

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? 

[Suvrutt_Gurjar]

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