How to create UNIQUE Filename

[Amod]

Hello all,
I am using IP2007 published on SharePoint library. This is a part of
SharePoint 2007 workflow.

I want to use a file name for this form when it is submitted by a user which
should be unique(obvious means) on the library and it should not get changed
when other user updates the form(as a part of workflow) which is why I am not
using something like date&time, username functions which would create
multiple entries for the same file/form data when submitted by multiple users
(& on different dates or times)

Also I tried using different field values for the filenames but that is only
possible in the combination of 2 or 3 different fields of the forms but then
how to concatinate them when I am creating the submit data connection for the
submit button in the form. something like this: "Order Date" & "Software
Name" will be unique if used together, but how to put 2 fields in the file
name?

Please suggest me a solution.
Sorry for the long query and let me know if I can make it more simple for
you to answer.

 

[infojetsoft]

Hi, please click the "fx" button near the file name textbox on the Data
Connection Wizard dialog, and click "Insert Function...", select Text ->
contact, OK, then you can insert the field "Order Date" as the first
parameter, insert the field "Software Name" as the third parameter, and
change the second parameter as " ", the file name will be like "2009-6-12
InfoPath 2010". Hope it is what you want.

 

[Amod]

Thanks for the reply.
I am using the same function concat() to create a unique name everytime, it
does create the unique file entry in the form library.
But when I try to open this through a email( having a link to this file), it
doesnot oepn since the filename has a space (in your eg.: InfoPath 2010),
instead it should be Infopath%202010, which is why IE is not able to encode
that space. Please suggest me how to encode it.

--
Thanks
Amod Goyal

Hi, please click the "fx" button near the file name textbox on the Data
Connection Wizard dialog, and click "Insert Function...", select Text ->
contact, OK, then you can insert the field "Order Date" as the first
parameter, insert the field "Software Name" as the third parameter, and
change the second parameter as " ", the file name will be like "2009-6-12
InfoPath 2010". Hope it is what you want.

 

[Amod]

Hello Swathi,
Thanks for the reply.
I am using the same function concat() to create a unique name everytime, it
does create the unique file entry in the form library.
But when I try to open this through a email( having a link to this file), it
doesnot open since the filename has a space (for ex: "softwareName" is Visual
Studio been entered in the form), instead it should be Visual%20Studio, which
is why IE is not able to encode that space. Please suggest me how to encode
it.

 

[infojetsoft]

Hi, maybe you can use the function translate(), like the following:
translate(concat(field1, " ", field2), " ", "+")
This will replace all of the spaces to "+". But if the filename contains
other special characters, I suggest writing some codes to encode it.
---
InfoJet Service, a web form engine for InfoPath.
Visit InfoJet Service at http://www.infojetsoft.com

Thanks for the reply.
I am using the same function concat() to create a unique name everytime,
it
does create the unique file entry in the form library.
But when I try to open this through a email( having a link to this file),
it
doesnot oepn since the filename has a space (in your eg.: InfoPath 2010),
instead it should be Infopath%202010, which is why IE is not able to
encode
that space. Please suggest me how to encode it.

 

[Amod]

That worked great for us. Thanks infojetsoft team.