InfoPath Dev

Hello, I am using Infopath 2010 and SharePoint 2010.

I have a form which a user completes - they press a submit button and this is then sent to the Sharepoint list.  I have set the filename of the uploaded forms to concat(Name, now()) - I have selected the 'Allow overwrite if file exists option'.

The approver then receives an email when a form has been uploaded.  This is then approved in the 'approver' view.  However, once this is approved a newer version of the form is submitted to SharePoint.  This is because the time of the filename has changed and therefore a new file has been created.  As the form goes through the approval process I am ending up with lots of copies of the same form because the time has changed on the filename.

Do you know if there is any way around this please?  I would like an initial submit to Sharepoint once the user has completed the form, but after this I just want to be able to save over the top of the original form, rather than upload different versions of the form to the Sharepoint library.

When I have added a new button to the form to save only, rather than submit I have found that there is no option for this.  I did try the 'Update Form' button, but this is only available when the form is being edited in a web browser.  My form is being edited with InfoPath Filler.

I have done some research online where you would add a hidden textbox with a filename using rules in the 'Form Submit' menu, but for some reason my 'Form Submit' menu on the ribbon has been disabled, I'm not sure why this is.

Any help would be much appreciated!

Thanks

Caroline

Hi Caroline-

Try this:

1. Add a field to your schema and call it "Filename".

2. Add a rule on load to set the filename with the condition "Filename is blank". This means that the filename will only be set on the first submit.

3. The Filename can be set to concat(Name, now()).

4. And the edit your submit data connection such that it uses this filename node as the filename in the SharePoint form library.

And that's it. You'll be overwriting, and the now() timestamp will only execute at the moment the form is first created. Good luck.

 Thank you so much, this worked :)