InfoPath Dev

I'm developing a browser based form that will have multiple people editing it before it's finalized.  I also need to have custom code run when the form is submitted/saved to the SharePoint library.

From what I understand, I can only write custom submit code - not save code - for a browser enabled form.  The problem I'm having is when another user opens the form makes changes and submits the form back to SharePoint, it creates a second record instead of updating the original form.

So my question is, how can I design the form such that I can have custom code run during the submit, and have additional edits update the existing form instead of creating a new one?

Thanks in advance...

I have not had much experience with SP2007 and browser based forms yet but I do know on SharePoint, at least with 2003, in the setup of the document library there was a place to insert custom code that would utilize a built-in trigger when something was saved there.  In was in the same location as linking a document library to a exchange public folder.  You would have to research this but this was one point where you could do some scripting on the SharePoint side when a document was submitted. Not sure if this would help but wanted to throw that out.

Thanks Clay,

I'll probably end up using the library events for emailing or security but I was hoping to use the submit event since it saves and closes the form at the same time - or it can cancel the submit entirely.  Not sure if I could get the same result from the library events...

I've got a working solution now by making the following changes:
- Stored the filename in a hidden field so it remains the same for each submit.
- Modified the data connection file so that overwrites are allowed.

It looks like SharePoint is smart enough to recognize that it's the same file (since it has the same filename) and updates the existing one.  So when I look at the items properties it has a creation date/time that's hours earlier than the latest save.

So it looks like it will work...I guess the only concern is 2 users creating a new form at the exact same second and the last one to save wins.

Well, I had the sane problem :) So my solution was:

1. I created Submit DataConnection to Sharepoint Library.

2. Then I created custom code for my submit button.

3. Write something like this:

public void btnSubmit_Clicked(object sender, ClickedEventArgs e)

{

//       My code here ....

       

         DataConnections["myDataConnectionName"].Execute();

         DataConnections["myDataConnectionName"].Execute();

}

Hope it helps ...

void btnSubmit_Clicked(object sender, ClickedEventArgs e)

{

//       My code here ....

       

         DataConnections["myDataConnectionName"].Execute();

         DataConnections["myDataConnectionName"].Execute();

}

Hope it helps ...

 

I`m sorry for misprints.... 

public void btnSubmit_Clicked(object sender, ClickedEventArgs e)

{

//       My code here ....

       

         DataConnections["myDataConnectionName"].Execute();

         DataConnections["myDataConnectionName"].Execute();

 

         DataConnections["myDataConnectionName"].Execute();

}

{

//       My code here ....

       

         DataConnections["myDataConnectionName"].Execute();

         DataConnections["myDataConnectionName"].Execute();

 

         DataConnections["myDataConnectionName"].Execute();

}

Something wrong with forum I think :(

How do you get the file name?  Do you have to add code to obtain?

Hello Board,

 I don't know if I understand the last posts correctly, but I have the following question.

 Is the a way (regardless how complex) to predefine the filename in browser enabled forms? I don't want the User to be able to set a custom filename. So when the user saves the form (not submit) the modal filename box should be prefilled or (even better) should't appear at all.

Can someone help me with some hints?

 Regards Michael

Hello it's me again,

does nobody have an idea how to manage this or can tell me, that it's definitly not possible?

Regards Michael

Michael77,

How did you resolve the issue of the Save/Submit options; I am tackling the same issue.

Thank you

I have followed some advice from this article

http://blogs.msdn.com/infopath/archive/2006/11/08/submitting-to-this-document-library.aspx

 

 

Basically you setup a submit using the wizard and then in your on submit code you modify the submit data source. Within the data source you specify the filename (can use a formula) and specify if overwrites are allowed.

 

Hope that helps 

That is the correct method. Essentially instead of save to a document library the user is doing a submit to a document library which saves but gives you more control.

Also there is OM that can be used to set the save filename which may also work with server forms.