I have a form with SaveOptions=“0” that I created for users to access common information such as phone numbers, addresses etc… So the form never gets saved by the user. But at the bottom of that form I need to show who last updated the form in designer. In Designer while looking at the “Views” of any database, it displays “Last Modified” & “Last Modified By”. How do I display the “Last Modified By” value in this form?
Where as the Code:
Last Updated on by .
…should read:
Last Updated on 12/10/07 by Jeremy Deal.
My first Computed Value is working correctly with a formula of “@Text(@Date(@Modified))” but I cannot get the second ComputedText to display the last modifier of the document? Any help would be greatly appreciated!!!
I’ve tried the following in the last ComputedText with no results:
Subject: Form to show who Last Modified it in Designer?
Are you trying to display who modified the form design (ie ‘in designer’ where you modify design elements) or are you saying only the designers can edit the document (which happens in the Notes client NOT in the designer client)?
If you want to know when the design was modified, there are no built in fields for that; your designers will just need to put some text on the form saying who did what and when.
If the designers are allowed to update and save documents (ie something changes SaveOption to not 0, then why not a field ‘WhoSaved’ which would be computed as @Name([cn];@UserName)?
Subject: RE: Form to show who Last Modified it in Designer?
“If you want to know when the design was modified, there are no built in fields for that; your designers will just need to put some text on the form saying who did what and when.”
Yes that is what I was trying to do. I was hoping since Designer shows you that information there was some way to display it in the form as well.
Subject: RE: Form to show who Last Modified it in Designer?
Well, there surely is a way, but I doubt it’s worth the hassle. You would have to export the design note to DXL, parse it, retrieve the piece of information you’re interested in and then display it.
You will not want to do that in an agent run every time that form is used, so a scheduled agent writing this info to a profile document would be your best bet. However, this would not always be up to date, making it somewhat useless.
Subject: RE: Form to show who Last Modified it in Designer?
I guess I could actually create a single document in the notes client with a giant RTF and allow only designers access to edit that field. Then change the button for users from “compose” form to “open” form based on its unique ID in read only mode. Then the field that records which designer last saved would be accurate.