InfoPath 2010

Re: autonumbering infopath forms

agavoky — Thu, 04 Dec 2014 17:39:29 GMT

Thanks again hillary

i would appreciate a step by step way to accomplish this

Regards

Re: autonumbering infopath forms

Hilary Stoupa — Thu, 04 Dec 2014 16:16:30 GMT

So - you could query the library, get a count of the forms, and increment it by one, then zero pad it get the next number. The reason I suggest doing this when you submit is to prevent two or more users getting the same number.

Re: autonumbering infopath forms

agavoky — Thu, 04 Dec 2014 16:11:18 GMT

the filled out forms are submitted to a SharePoint forms library

Re: autonumbering infopath forms

Hilary Stoupa — Thu, 04 Dec 2014 16:04:24 GMT

No - because you don't have a way to know how many times the template has been opened. You don't know how many filled out forms have been saved.

You'd need to have a way to find out what the number should change to - have 100 forms been filled out? 5? 21? The form logic needs to be able to find that out and set the number accordingly. That's why I have been asking where the filled out forms are submitted.

Re: autonumbering infopath forms

agavoky — Thu, 04 Dec 2014 12:52:35 GMT

Hello Hillary

I want to thank u for your assistance thus far.

I want the infopath forms autonumbered before they are saved.

i have a text-box field called autonumber on my infopath form. i have set the default value to 001.

Each time a user opens the form i want the number to change to 002 and so on

is this possible

Re: autonumbering infopath forms

Hilary Stoupa — Wed, 03 Dec 2014 15:21:54 GMT

Hi, agavoky - I did understand you. I was making a suggestion for how you might accomplish this if your form submit to SharePoint. Do they? Or do they submit to SQL? If not, unique numbering is going to be pretty challenging - and even if they do, it can be hard.

Re: autonumbering infopath forms

agavoky — Wed, 03 Dec 2014 08:31:03 GMT

Hello Hillary

thanks for your response

i think u missunderstood me

on the infopath form, i have a field called NO:0987

each time a user fills the form they should each have a unique number, this will allow for auditing of each of the forms

Re: autonumbering infopath forms

Hilary Stoupa — Wed, 03 Dec 2014 00:02:40 GMT

Where do you save your filled out forms? SharePoint? If so, you could get the max ID from the SharePoint library right before you submit the form and increment it by 1 - there is always a risk that two people will end up with the same number, but querying the library right before you submit minimizes that.

autonumbering infopath forms

agavoky — Tue, 02 Dec 2014 08:38:10 GMT

Hello people

i just created an infopath form for petty cash

on the form i have a NO:0023 field that i want to be autonumbered when a new user fills out the form

in essense what am trying to say is that the NO: filed changes for each filled petty cash form

please how can this be done