InfoPath Dev

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 ...

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.

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 ...

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

I'm creating an InfoPath 2007 browser enabled form in Infopath designer 2010 and following are the details: Person #1 initiates the request and sees View #1. They submit to InfoPath form library and an email goes to Person #2. That person opens up the form and sees View #2 that allows them to add their approval, notes and then there is a ...

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?  

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.

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  

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", "")

I have 1 data connection that is used by all of my drop downs. My data connection has a single query. Without getting too detailed, the query looks something like this: Select Col1, Col2, Col3 From Table Then my drop down properties uses the result set and filters the result set based on col1 = "some text", and sets ...