Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Infopath filled out form update

Posted on 2012-04-03
4
Medium Priority
?
618 Views
Last Modified: 2012-04-03
I have an InfoPath form and it is used by a SharePoint library. When the user fill out the form they submit it to the library. When the form needs to be updated i need a way to just update the existing form instead of creating a new one. I have a submit button and a save button but i think i need a 'Save As' button. this is for a time tracking list so people earn hours and enter them. Then a manager goes into the form and deducts time. but its the saving it back that i the issue.

Help Please
0
Comment
Question by:Netadmin2
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 37802825
Normal Best practice would be:
They would find the submitted form they want to update.
They would open it.
They would make the changes.
If they submit again it may overwrite the previous, if you want this you can enable overwrite for the library.
If not then you would need logic on your submit data connection that changes the file name to be submitted (saved) which is your "Save As"

A lot depends on how you are naming the forms.  If there is a dynamic element, such as a date or time stamp. Then the next time it is saved it should recalculate.

Typically I would create an incremental that would maybe put a 2 or something behind it. I would add a field to the form that defaults to 0.  Add another action to submit that increments this field, before the submit.  Also you a formula to create the file name.  Concat this field on the end and you would have an incrementing count.  Just an idea.
0
 

Author Comment

by:Netadmin2
ID: 37803166
The submit for the form does an auto name from in Infopath. Concat(username()," - ",now()). And i couldn't make a save button that would pull in the original name created when originally submitted. When the user goes to edit they click the name and it opens the form. Then they change and i need it to save as the same form not create a new one.
0
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 37803239
ok, so here is what you do.

Create a field called createdate

when a form is opened new set the createdate to now.  you could add a rule on open that is createdate is blank set to now().  If it already has a vaule that will be skipped (existing form)  

go into the submit data conneciton for the library. and replace the now() with the createdate field.  This way it is not set each time but references the createdate field which will be set once.

This way you wil keep the same form name.  Make sure in the library properties to allow overwrite.
0
 

Author Closing Comment

by:Netadmin2
ID: 37803521
Thank you very much. This is great, just like i was hoping it would do.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question