Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2005

Tip: Looking for answers? Try searching our database.

How do I display the last person that modified a sharepoint form?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bernie Hsu - 13 Jul 2005 01:21 GMT
I'm using Infopath to create forms.  
Renee in Juneau - 13 Jul 2005 02:49 GMT
Change the sharepoint view so that it shows the "Modified By" field.

>I'm using Infopath to create forms.  
Bernie Hsu - 13 Jul 2005 20:00 GMT
Sorry I was not clear in my question.  I'm trying to create an electronic
approval  expense form.  So one person would create the expense form and then
a supervisor sign off on it.  I want to list on the form who last modified
it.  This way I prevent anyone else from modifying the info on form without
the supervisor being the last one to review and approve it.  So I need to
capture whether the information on the form was modified and if so, the user
name.  Is that possible in Sharepoint?  Or is there a better way to track an
electronic approval?

> Change the sharepoint view so that it shows the "Modified By" field.
>
> >I'm using Infopath to create forms.  
Renee in Juneau - 13 Jul 2005 20:26 GMT
Sorry.

There's probably a lot of ways to do this, but I would create a
"whoami" web service (see other posts) and add a readonly field with
the label "Last Modified By".

Then I would go into Tools/Form Options/Open and Save and check the
"Save Using Custom Code" box, edit the code and add a line that
assigned the field's value to the whoami result immediately before the
form is saved.

But on second thought, I guess it would be better to create a rule
that assigned the fields value when the form was opened (also in
Tools/Form Options/Open and Save). This way, the user would see that
their name was on the form as the last modifier. Shucks. Downside is
that if a user opens the form, they'll see their name whether or not
they've made a change to it.  If they don't save it, the field keeps
its original value.

Nah.

FWIW, in the situation you describe I would also be making heavy use
of user roles and assigning views appropriate to those roles. For
instance, the form defaults to a read only view and when the user
changes it to a view that allows modification, *then* set the "last
modified by" field.

Choices, choices. :)

>Sorry I was not clear in my question.  I'm trying to create an electronic
>approval  expense form.  So one person would create the expense form and then
[quoted text clipped - 8 lines]
>>
>> >I'm using Infopath to create forms.  
 
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.