Make Sequence unique id

AppSheet AppSheet Q&A
1

Hello,
I have column [Store Number] which include unique id Start with (BM) and sequence number

Ex : BM307 , BM308 , BM 309 .

what the formula can use it to make it automatically and show it for user when start add new item?

2

“BM”&right(“000”&(number(right(maxrow(table,_rownumber),3))+1),3)

3

Thank You it is work but when i edit one any previous item change for last [store number]

@Hocappsheet

4

Use @Hocappsheet 's expression in Initial value, not in App formula.