Submit Filename

[John H.]

I am using the Submit options to build the form filename when it is
submitted. I would like this to be a combination of text and a sequential
number (XXX-999). The form is submitted to a Form Library in Sharepoint.
Is there a way to get a sequence number? I'm trying to avoid possibly
having a form submitted with the same filename, causing a version to occur
with invalid data.

Thank you.

John

 

[Nezih Tınas ( MVP )]

Hi,

There is no built-in number generator or sequence manager in InfoPath or
SharePoint. But, when the user submits the form, you can get the biggest ID
on the Form Library and add 1 to the ID, then submit the form with that
name. This is possible.

Have a nice day...

 

[hoda007]

Hi Nezih,

I am already using the @ID value returned,
but I am having difficulty extracting a value for ID when the library is
empty.

The NZ(@ID) function doesn't handle it, It can't handle the NaN value
returned.

I could use a conditional statement and the Boolean(@ID) function, to
hardcode the value to 1, even though the real @ID value can be something
else. then the next number has a big gap since it will be reading the real
@ID.

Is there anyway to extract @ID from the Library whether it is empty or not?

Thank you