How do I create an auto-increment box in an InfoPath form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat in Georgia - 28 Mar 2006 15:40 GMT

I have modified the Purchase Order request form in InfoPath. I would like
the reference block to automatically create an incremental id number whenever
someone submits a request.

How do I do this?

Reply to this Message

Ben Walters - 28 Mar 2006 23:50 GMT

Hey Pat
This is very possible, you will however need to have Service Pack 1
installed, and I'm also making the assumption that you are submitting your
forms to a SharePoint Form Library and that your Reference number in the form
is being used as a field in the form library. Basically what you will need to
do is create a data connection to your form library that retireves the
reference nubmers from the form library. Once you have this connection you
can then write some custom Submit code that takes the last refeence number
adds 1 then submits the form into the library.

If you need any more info or sample code let me know and I'll post some up

Cheers
Ben

> I have modified the Purchase Order request form in InfoPath. I would like
> the reference block to automatically create an incremental id number whenever
> someone submits a request.
>
> How do I do this?

Reply to this Message