 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / July 2008Updating a SharePoint Filename upon Changes to the form.
I have an InfoPaht 2007 form that is submitting both to a database and a SharePoint Document Libary. The SharePoint filename is generated automatically by concatenating fields in the form. I have some users who can audit the SharePoint Document and resubmit back to the database. My problem is that if any of the fields for the concatenating filename is changed, I want the SharePoint Document name to also change, but it retains the original filename. We are keeping the SharePoint Documents as reference forms so the users need to be able to find the filight in question. I don't want to create a different document but update the filename when it's submitted back to the database. Is there a way to do this? And can I do it with a rule without writing code? For Example a filename would be submitted as LM0190801162245, which is an aircraft name, year, month, day, hr, and minute (Aircraft and complete time of flight). If the plane changes to LU014, I now want the same SharePoint file with a filename of LU0140801162245. Thanks siboyd > I have an InfoPaht 2007 form that is submitting both to a database > and a SharePoint Document Libary. The SharePoint filename is [quoted text clipped - 15 lines] > Thanks > siboyd I guess, you have answered your own question. You can use the plane name field to produce the file name. If the plane name doesn't change, after submitting to the library, it will create a new version of the form. If the plane name changes, after submitting to the library, it will take the new plane name to create the form name. Thanks, Paresh > > I have an InfoPaht 2007 form that is submitting both to a database > > and a SharePoint Document Libary. The SharePoint filename is [quoted text clipped - 27 lines] > > - Show quoted text - I agree with your first If... it will update the changes on the existing form and retain the same filename. My form is not doing as you indicate in the second if. My form will save the changes made within the form on the SharePoint file but the filename is not changing. It's retaining the same filename as before the concatenating fields were changed. Are you using a Save or a submit to SharePoint. Are you using code or standard data connections? Typically people have the opposite problem, a new form is being created when they want the old one updated. Once you get a new saving, (Should be with a submit) then you can use a CAML to delete out the old form if that is what you want.  SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > > > I have an InfoPaht 2007 form that is submitting both to a database > > > and a SharePoint Document Libary. The SharePoint filename is [quoted text clipped - 33 lines] > file but the filename is not changing. It's retaining the same > filename as before the concatenating fields were changed. On Jan 29, 10:26 am, Clay Fox <Clay...@discussions.microsoft.com> wrote: > Are you using a Save or a submit to SharePoint. Are you using code or > standard data connections? [quoted text clipped - 48 lines] > > - Show quoted text - The form is submitting to a SharePoint library and a database. We have an edit person that will pull the forms up from SharePoint each day, check them and resubmit them back to the database. So if the fields are changed that created the filename, it retains the filename and I would like for it just to overwrite the file with a new filename. The form has a primary key field included that links all of the database tables. Could I somehow build a rule based on that? On Jan 29, 10:26 am, Clay Fox <Clay...@discussions.microsoft.com> wrote: > Are you using a Save or a submit to SharePoint. Are you using code or > standard data connections? [quoted text clipped - 48 lines] > > - Show quoted text - I forgot to say we are using Standard data connections. What is CAML? It should be simple. Are they using Save or submit? You could try having two submits as well. But you should be able to verify the second file name before submit and that would create a new document if the name is unique. You could also turn off overwrite in the library. I am guessing they are using save rather than a submit, I think this would give the behavior you describe. I typiclaly turn save off and force the user to use submit so that you have control of what happens. The CAML is used to be able to delete a file from SharePoint. You can search on it on http://www.infopathdev.com and find instructions. Once you have it saving with a new name you will likely want to clean up the old form. You may need to save the old name so that it is eacy to erase. SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > On Jan 29, 10:26 am, Clay Fox <Clay...@discussions.microsoft.com> > wrote: [quoted text clipped - 50 lines] > > > > - Show quoted text - I forgot to say we are using Standard data connections. What is CAML? http://baigadil.blogspot.com/2008/07/get-current-user-for-infopath-and-set_2480.html
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.