Purchase order numbers

[bclark]

I'm looking for a way to have a unique number field for the purpose of
identifying Purchase orders. We are using Infopath 2007 and Formserver, so I
would like to use a web enabled form. I am able to use time as a unique
number, but the 2007-06-21T09:23:01 format is not very good for our
purposes. I would like to either combine to fields like username and datetime
to come up with a unique number like bclark070621092301 or even just
070621092301
Has anyone had any success coming up with a way of achieving this?

 

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

Have you already tried using the concat(), substring(), now(), and userName()
functions? A combination of these should give you want you need. See
http://office.microsoft.com/en-us/infopath/HA012330391033.aspx

 

[bclark]

Thanks, was able to fashion something workable from those options.

Ended up Creating a hidden field for username called user and using this
formula.

concat(substring(User, 1, 2), " ", substring-before(now(), "T"), " ",
substring(substring-after(now(), "T"), 1, 5))