Create unique ID for every submission

[Martin Eckart]

Hello,

I have a form which is filled out and sent to one single contact every time
someone has a request.

The requested person needs a unique ID for every form. I suggested using
Email adress in conjunction with date and time but this did not suit his
needs. He wants to have a numeric one.

Is there a way how to implement that in Infopath? I am not storing the forms
anywhere, only Emails to be sent out. The criteria the number must fulfill
are only:

- numeric
- unique

No need for it to be ascending step 1 and also no need for it to make any
sense. It just shouldn't be like any previous one.

Thanks,
Martin

 

[Adam Harding]

Linking the form to a database (see elsewhere on this board) would provide
the funtionality.

On submission of the form the USERID would log itself in the database and
return the ID Number which is guaranteed to be unique as it is only generated
once the data is written into the table.

Otherwise you can do the whole date time thing without any non-numeric
characters ie 18 April 2006 11:21:56 would be
04082006112156

Also unique.

Hope this helps.

Cheers Adam

 

[Abhishek Keshav]

Hello,

I have a form which is filled out and sent to one single contact every time
someone has a request.

The requested person needs a unique ID for every form. I suggested using
Email adress in conjunction with date and time but this did not suit his
needs. He wants to have a numeric one.

Is there a way how to implement that in Infopath? I am not storing the forms
anywhere, only Emails to be sent out. The criteria the number must fulfill
are only:

- numeric
- unique

No need for it to be ascending step 1 and also no need for it to make any
sense. It just shouldn't be like any previous one.

Thanks,
Martin

 

[Abhishek Keshav]

Check out this link in InfoPathdev.com for the answer.
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2102

 

[Greg Collins [InfoPath MVP]]

You can only guarantee the unique ascending number by using a database. It creates a new row each time you call into it for the number.

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


Hello,

I have a form which is filled out and sent to one single contact every time
someone has a request.

The requested person needs a unique ID for every form. I suggested using
Email adress in conjunction with date and time but this did not suit his
needs. He wants to have a numeric one.

Is there a way how to implement that in Infopath? I am not storing the forms
anywhere, only Emails to be sent out. The criteria the number must fulfill
are only:

- numeric
- unique

No need for it to be ascending step 1 and also no need for it to make any
sense. It just shouldn't be like any previous one.

Thanks,
Martin