InfoPath Dev

Ah, I see - so it isn't like there is just a button you can disable. I would probably test with updating the form name on the next save, just to see if it worked - but I would probably also add some logic to prevent saving if the name hadn't been updated. Add an "original name" field or something so you can compare the current ...

 So, I'd guess you would want to set the ID field with something like this: xdXDocument:GetDOM("Teams_roster")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[count(current()/../preceding-sibling::my:group2) + 1][d:Dept = XPATH TO YOUR DEPT FIELD]/d:ID With the bold part being the main data source field (or ...

I think there are still some risks, sure - I don't know what all the various logic or buttons you have in your form are. :) Another option may be to push this to the user, in a way. Have a field in the form (not displayed) indicating whether the updated file name has been retrieved & disable "Submit for Approval" until it has. If ...

How about if Save & Continue is only possible after the first submit? Then, the form's name is updated, they can re-open from the library and continue on their way? Or, perhaps you check for that file name as the first step on your "Save & Continue" - skip it for new forms that haven't been submitted, but for forms that ...

Can I see your form? You can email it to me if you don't want to post it here...

Got it. So - is this library heavily used? One way to do this is to query the library right before you submit to return the ID numbers & get the max(ID), then use it in the form name. If the library gets a lot of traffic, you run the chance of having someone else get the same ID tho - both query at the same time before the submit is complete.

I have a silly question - why can't you just use the "Form Type" for the name to begin with?

Oooh, even the solution was yours! Don't feel silly, over the years I seem to have forgotten 1/2 of what I've learned about IP. :)

I'm attaching a sample with validation rules for this. Save the file locally, right click and select design. Preview and in the first column enter the same text for one or more rows in the tables. Enter whole numbers in the second column - when they get above 100 for the same "person" you'll see the validation rules fire. :)

Any chance I could see your form? You can attach it under the Options tab in a reply - it is hard for me to find a 1/2 hour to review a video to try to figure out what the issue may be.