Is there any way to create a form field that will auto-number when the submit box is clicked? I am in the process of creating a complaint form and would like to auto-populate the Complaint Number field if possible.
Hello,
Can you please clarify the 'auto-number'? Do you want the number of forms that are submitted?
For eample, a citizen fills out an online complaint form. This complaint will be Complaint #1000. The next citizen that completes a complaint form, it will be Complaint #1001. Just trying to find a way to avoid having a manual process of assigning consecutive numbers when the form is submitted.
Hello,
Unfortunately, there is no direct way to get that number. However, it will be possible to get the number, if you use stored procedure and lookup rule together. You will need to write your own stored procedure to query the database and get the number of forms that are submitted, and use lookup rule to fill that number into the field in the form.
Is this something which will be released in a future release?
Hi there,
I have the same issue where I want the form to automatically number contracts. My only requirements are that it's numerical and unique. I'm on 10.3 Forms Professional. I created a "Contract Number" field and was thinking about having it to default the the Instance ID of the form. When I test it, nothing comes up in the field.
However, when I use Business Process ID, I do get a number in the field. What's the difference between Business Process ID & Instance ID. Will Business Process ID stay the same through out the process until the form is stored in the repository?
Thanks