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?

The initial value will be: “BM” & (COUNT(UNIQUE(Table Name[Store Number])) + 1) Make sure to have [Store Number] allow no edits in the form view. Also please read below. [Screenshot 2025-01-13 115239.png]

sequence unique id

AppSheet AppSheet Q&A

Aurelien January 14, 2025, 5:59am 3

in addition:

Serial Numbers, If You Must - Google Cloud Community

3 Likes

Topic		Replies	Views
Make Sequence unique id AppSheet Q&A expressions	3	4	January 4, 2025
Unique id self making AppSheet Q&A expressions	5	1	April 10, 2019
How to make sequential number? AppSheet Q&A admin , automation	17	13	April 23, 2024

sequence unique id

AI Suggested topics