Unique id self making

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

0016 need to count 1 up every order i make.

Thanks

@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.

1 Like

@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”.

1 Like

@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.

1 Like

@Erwin_Demeulder
You can read this page also:

1 Like

Tanks for the answer