I would like to be able to add a unique number that increases sequentially to each form. This would be helpful in adding the submissions to another database.
I would like to be able to add a unique number that increases sequentially to each form. This would be helpful in adding the submissions to another database.
Can you use the Entry ID? It is a unique number that increases with each form and is sequential, although across all forms.
I have looked at the entry ID, but we have over 40 forms and I only need this numbering on one form, so using the entry ID would leave lots of holes in the numbering.
There isn't currently a built in feature for doing this, although it is a feature we would like to add in the future.
Why not store the Entry ID in the third party database and generate a sequential unique ID in that database also? If you are adding the submissions to another database anyway, you could generate a sequential ID when you create a new record in that database.
Your other option is to use custom PHP and write a customization. Create a hidden field on your form to store the ID, then populate that ID using PHP. Each time the form is submitted you'd query the entries for that form to get the last ID and then increment it and store the value in the hidden field. That is another solution. you'd have to use the available API hooks and write some custom PHP to do this.
Would like to resurrect this post.
Carl your last comments very quickly turn into white noise for my limited PHP knowledge, the only thing missing from these forms is a unique ID per form.
@andypaddock, please start a new topic with your request and we will be happy to help you accomplish what you're looking to do. Thanks.