 |
 | 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 2005reset of default values on edit
I created a form that is shared on a form library in SharePoint. One of the fields, TrackingNumber, is a concatenated key for the form and 3 of the 4 parts of this keys values are generated by other fields values within the form. For instance, the first part is a current date string - 20050701, the second is a location code - AZ, the third is initials of a person - AB, and the fourth is a 3 digit number to be entered by the user. So when the form opens the default value is set to 20050701AZAB, and data validation makes sure the user tack the 3 digits onto the end. This all works fine, the problem is when a user re-opens the record the default value resets the TrackingNumber in the form back to 20050701AZAB and I loose the last 3 digits that where manually entered? Any way to retain this value for this field and only define the default value for the field when it's a new record and not on edit? Thanks! Bob Have your code only update the field if it starts off blank.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I created a form that is shared on a form library in SharePoint. One of the fields, TrackingNumber, is a concatenated key for the form and 3 of the 4 parts of this keys values are generated by other fields values within the form. For instance, the first part is a current date string - 20050701, the second is a location code - AZ, the third is initials of a person - AB, and the fourth is a 3 digit number to be entered by the user. So when the form opens the default value is set to 20050701AZAB, and data validation makes sure the user tack the 3 digits onto the end. This all works fine, the problem is when a user re-opens the record the default value resets the TrackingNumber in the form back to 20050701AZAB and I loose the last 3 digits that where manually entered? Any way to retain this value for this field and only define the default value for the field when it's a new record and not on edit? Thanks! Bob Hi Greg, thanks for the response but I'm not sure I understand where I would do this. In the field properties I set the Default Value to be a function that defines the its value except the last 3 numbers, which is basically a counter, so the user enters it. When someone reopens the form after its been save it redefines that Default Value without those last three numbers because thats not part of the function in the Default Value property. How can I set it so it only sets the Default Value so it only works when it hasn't already been defined? Thanks, Bob > Have your code only update the field if it starts off blank. > [quoted text clipped - 14 lines] > Thanks! > Bob You'll have to move away from using a default value to using code (specifically within the OnLoad event handler)... then you can first check if a value doesn't already exist before adding one. Now, you might also check to see if you have selected the Update This Value When the Result Of The Formula is Recalculated check box. If so, clear that check box and see if that fixes you problem first. If not, you'll need to move away from using a default value to using code. Code allows much more flexibility and control to prevent such issues. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Hi Greg, thanks for the response but I'm not sure I understand where I would do this. In the field properties I set the Default Value to be a function that defines the its value except the last 3 numbers, which is basically a counter, so the user enters it. When someone reopens the form after its been save it redefines that Default Value without those last three numbers because thats not part of the function in the Default Value property. How can I set it so it only sets the Default Value so it only works when it hasn't already been defined? Thanks, Bob "Greg Collins [InfoPath MVP]" wrote: > Have your code only update the field if it starts off blank. |
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.