Hello,
In the past, I have tried coming up with solutions similar to what can be done on-prem with auto-incrementing a number in Forms. The on-prem solution involved executing a stored procedure in SQL when the form was opened, which pretty much guaranteed you'd always get a unique number, unless you somehow opened the form at the exact same microsecond as someone else.
Cloud Forms is a little different. I know there are other unique values that can be used for this, but for things like purchase orders, it's nice when purchase order numbers follow a certain sequence. Does anyone have a solid solution for this in Cloud, where you've pretty much eliminated the chance of a duplicate value, and you've kept your numbers to values that are easily readable and in sequence with each other?
Thanks!
Question
Question
Cloud - Forms - auto-increment a number
Replies
We utilize a stored procedure (SP) in SQL to generate and reserve a number within the same request. This SP is invoked using Power Automate, which is triggered through a Laserfiche connection and rule. The rule is executed via a service task after the form is submitted, following the message start event.
While modern web request rules can be triggered directly within a live form, we chose to implement the post-submit approach to prevent numbers from being allocated unnecessarily during the form creation phase. If a user were to abandon the form mid-process, numbers would still be reserved, leading to gaps and non-sequential assignments.
By deferring the number allocation until after submission, we eliminate this issue and ensure sequential numbering integrity. This approach allows us to maintain clean and efficient number management while avoiding unnecessary reservations.