Assign identification to a form

[dianah]

Is there a script that can be written in visual basic to attach to a form
that will auto generate a number each time a form is filled out? Seems like
a basic concept but I can't find anything about it.

 

[Franck Dauché]

Hi Diana,

Autonumber based on what? a central DB, all the local copies of 1 form? Do
you have more than 1 user using that form?

Regards,

Franck Dauché

 

[Franck Dauché]

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=723

Regards,

Franck Dauché

 

[dianah]

I have forms that a user will fill out and submit to SharePoint. There is no
uniques "title" or other identifying info when submitted. Another user could
come along and fill out the form with the same information in the title field
and it would overwrite or just not save this totally new submission to
SharePoint. The only fix I have been able to come up with is to have the
user enter the title plus a description which would have to be different
everytime. This is kind of like using a change request form and having the
CR field as the title field and making the title CR-1, CR-2, CR-3, etc.,
however I cannot depend on the user to number or uniquely identify the
request they are submitting by the title, so I thought if there was an
auto-generate feature already built in to InfoPath I could use that as the
"title" and relieve the user of having to do anything. Or would this need a
VB script?

 

[Paul Webster]

I have forms that a user will fill out and submit to SharePoint. There is no
uniques "title" or other identifying info when submitted. Another user could
come along and fill out the form with the same information in the title field
and it would overwrite or just not save this totally new submission to
SharePoint. The only fix I have been able to come up with is to have the
user enter the title plus a description which would have to be different
everytime. This is kind of like using a change request form and having the
CR field as the title field and making the title CR-1, CR-2, CR-3, etc.,
however I cannot depend on the user to number or uniquely identify the
request they are submitting by the title, so I thought if there was an
auto-generate feature already built in to InfoPath I could use that as the
"title" and relieve the user of having to do anything. Or would this need a
VB script?

:

I have gone about this by holding a table in a central database with a
unique identifier field that holds a serial number that increments
everytime that a record is added.
I have then written a webservice in C# that generates a GUID, inserts
this into a second field in my database table and then returns the GUID
and the unique identifier.
I have set up this webservice as a secondary datasource for my Infopath
form and use it to populate a couple of fields on submitting to SharePoint.

Paul Webster