Autonumbering

[AYReg]

Is there a way for a form to automatically be numbered prior or after
submission? For example, I'd like for the user to submit the form and
InfoPath automatically generate a number for that particular form (with the
number clearly seen on the form prior or after submission).

Thanks.

 

[Mias]

Under Controls insert a Text Box into your form.

Double click on the Text Box and in the value box you enter the rule that
will make it unique. In my case i have used the following formula (you can
copy and paste):

concat("#", substring(translate(translate(translate(now(), ":", ""), "-",
""), "T", ""), 3, 12))

The result is that it gives you a unique # based on the Year, month, day and
time (down to the second) that the form was opened.

I also de-selected the button underneath that states " ...Update this
Value..."

I hope this helps.

Mia

 

[AYReg]

Mias - I appreciate your response.

Is there a way to simply just number the form in a sequence such as (001,
002, 003 etc.)? Thanks.

Alex

 

[S.Y.M. Wong-A-Ton]

If you're submitting to a SharePoint form library, you can use the ID of the
last form together with rules and formulas to generate a new number for your
form when it is submitted.

 

[Eddy-T]

Ayreg,

I would like to do the same thing but be able to restart the numbering
after the end of the year. So if you hear something I would like to know
about it as well.

 

[AYReg]

Will do. And if you find out anything regarding Autonumbering, please let me
know as well. Thanks.

Alex

 

[wajackson]

How do you get the last FORM ID?

Thanks

If you're submitting to a SharePoint form library, you can use the ID of the
last form together with rules and formulas to generate a new number for your
form when it is submitted.

 

[S.Y.M. Wong-A-Ton]

You can use the max() function on a secondary data source. See
http://enterprise-solutions.swits.n...nfopath-form-submitted-sharepoint-library.htm for an example.