Infopath saveas in sharepoint overwriting

Question

I need help getting an infopath form to not overwrite existing files going to a sharepoint library.

I have an infopath form with a custom submit. In the submit I am doing "me.saveas(http:\mysharepointlibrary\FormDropDownValue)

This is working just fine. But, if I create a new form and pick the same drop down value I can't get the form to not overwrite the old one. I also tried me.save() and me.submit(), both of those bomb.

I have the data connection set up to not allow overwrites, but it doesnt even seem to go into that connection to make the save. I think because of the custom submit code.

Any help will be greatly appreciated.

Answer 1

Well you need to add something else, a dynamic and unique value as part of your form name. This can be done without custom code, from InfoPath Interface.

Configure new submit option and use a formula to generate form name. In my case I am using the following:

concat(YourFieldValue; now())

It will concatenate value from your field and current date-time. In case you have some other unique values on your for like username add these to the concatenate function as well.

_{(source: sharepointusecases.com)}