Unique id self making

[Erwin_Demeulder]

For every order i need to make a id example(BB 0016-2019)

0016 need to count 1 up every order i make.

Thanks

[LeventK]

@Erwin_Demeulder
Do you have multiple users for your app? If yes, sequential numbering could create double order ids when 2 users are creating a record at the same time.

[Dave2]

@Erwin_Demeulder You can use a MAX expression to generate sequential order numbers, like this:
MAX(Orders[OrderNumber])+1
It is not recommended that you use this a row key ID, however, unless there is only one user creating orders as you risk generating “duplicate keys”.

[LeventK]

Dave:

@Erwin_Demeulder You can use a MAX expression to generate sequential order numbers, like this:
MAX(Orders[OrderNumber])+1

@Dave
Pay attention that the type of id that @Erwin_Demeulder requesting is Text and your proposed expression cannot provide that I’m afraid. However, you are right that sequential ordering/numbering is not advised. Just FYI.

[LeventK]

@Erwin_Demeulder
You can read this page also:

help.appsheet.com

Sequential Keys

A technical rationale for why AppSheet can't support sequential keys.

[Erwin_Demeulder]

Tanks for the answer