General

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 23:59:11 GMT

Perfect, thanks!

Now I get the best of both worlds.

Re: Get the documentID

Hilary Stoupa — Wed, 11 Apr 2012 23:53:21 GMT

I'd query that data connection as part of the submit rules - submit rules would be like:

Query library to get IDs
Set field to concat("OP", max(ID) + 1)
Submit form

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 23:45:27 GMT

ok mystery solved! The data connection that was getting max(id) wasn't getting the value when the form was loaded so my *guess* is that it didn't have a value to use when naming the form.
This is unfortunate as I was hoping to not get this value until submit as there could be a clash if 2 people create a new doc at similar times (much less likely to clash if retrieving the ID on submit)
Can I get the value at submit or must I "carry" it with me as the form is being filled out?

Re: Get the documentID

Hilary Stoupa — Wed, 11 Apr 2012 23:36:03 GMT

Coffee helps with InfoPath. :-)

If you are retrieving the ID, the initial concat should work. But add a calculated value to your form that shows the max ID from your secondary data source - make sure that is returning what you'd expect. Then you can troubleshoot from there.

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 23:34:00 GMT

Not sure what my reasoning behind the 01 was, can just as easily be 1 - making the doc name OP1.xml
Will give that a go now.....

...

Same deal - renamed the existing doc to OP1.xml and the next file becomes OPNaN.xml

I just had a thought, given that I am retrieving the ID and not the filename of the doc, why am I messing with OP?
Rhetorical.
I think I need another coffee.
I need to retreive the ID add 1 to it, then prefix it wil OP and make this the filename. For some reason I have been working as though the ID was prefixed with OP.

Will report back

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 23:28:27 GMT

I have created an intial doc to ensure we have a max(ID), the doc currently in the library is OP01.xml
Letter O, letter P, zero, one

Re: Get the documentID

Hilary Stoupa — Wed, 11 Apr 2012 23:09:15 GMT

Well, the zero padding is also going to be a challenge.

When do you plan to zero pad? Only if the number is a single digit?

Re: Get the documentID

azandbergen — Wed, 11 Apr 2012 22:55:36 GMT

You might be getting NaN because there are no documents in the library, and therefore Max(ID) returns NaN. Upload a dummy/blank document to get ID =1 then you should be okay. Once there is another document in there, you can delete the blank document.

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 22:06:14 GMT

Thanks so how do I string (so to speak) that all together.
Say the last used doc name is OP01.xml, I need to save the next as OP02.xml

Re: Get the documentID

Hilary Stoupa — Wed, 11 Apr 2012 21:38:17 GMT

I see, you are getting back a string - I'd thought you were returning the actual list item ID, which is a number.

You could use translate to get rid of the OP:

translate(id, "OP", "")

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 21:33:59 GMT

Now I get OPNaN.xml

The problem is (or at least this is the problem in other programming) that OP01 is being treated like a string.
Somehow I need to say, extract the number portion from the string, add 1 to this number and then put the OP back on and use this as the form name.
Simple with a full range of string functions to work with but I don't see them in the formula builder

Re: Get the documentID

Hilary Stoupa — Wed, 11 Apr 2012 21:07:32 GMT

You need to use a concat formula:

concat("OP", max(id) + 1)

Re: Get the documentID

Jay@Work — Wed, 11 Apr 2012 20:21:50 GMT

ok plan B
I have created a data connection that gets the max ID from the list on submit and adds 1 to it and names the doc with this.
This is good as it should reduce the chance of 2 people saving at the same time and having the same max()

Problem is that the naming convention is OPxx.xml where xx is the sequential number.
So "OP" + max(id) +1 results in NaN.xml which is what I would expect.

There seems to be very limited functions when using browser forms - normally I would use a combo of left() and length() to get rid of the "OP" and then put it back afterwards.

Any ideas?

Re: Get the documentID

Hilary Stoupa — Tue, 10 Apr 2012 21:53:35 GMT

There is an id - but the issue is getting it before your file is submitted, since you say you want to use it for your file name. It is generated when the file is added to the library. You can query the library and get back all the current IDs and increment the max by one and hope that no one submits a different form before the form you are currently submitting is saved.

Re: Get the documentID

Jay@Work — Tue, 10 Apr 2012 21:43:41 GMT

The library also has columns so that people can view/edit properties on any given row so it appears to be a list in every way except that the main content is a form.

Would there be a list ID associated with this library that I could use?