How populate NewForm with auto incremented number or counter BEFORE saving item? - e.g. new order number

Discussion created by ArdeviaForum on Aug 17, 2016
Latest reply on Aug 17, 2016 by ArdeviaForum

Original Post by Alexander (Imported from Ardevia Forum)


I know items have IDs and workflows can add and count numbers, which make life easier just AFTER an item is saved.
However, I am stuck with a scenario when a users needs:

  • - create new item (NewForm)
  • - generate next autoincremented number (order number/transaction number) BEFORE the item is saved.

The only way seems to make some calculations on NewForm during user input.
(At the moment we force users lookup and input it manually, which is not error-proof)

Is there a way to use actions or expressions to:

  • - look for previous last number taken by other items
  • - and add +1 to increment?

If so, please, help me.