troubleshooting Question

How do I lock-down fields in Domino Designer so they can not be edited by a Lotus Notes client?

Avatar of fselliott
fselliottFlag for United States of America asked on
Lotus IBM
5 Comments1 Solution1531 ViewsLast Modified:
Typically, our databases were created with the following Lotus Script in the Querymodechange:

Sub Querymodechange(Source As Notesuidocument, Continue As Variant)
      Dim doc As notesdocument
      Dim session As New notessession
      Set doc=source.document
      If(doc.GetItemValue("status")(0) <>"Draft" And "Sue Smith" <> session.CommonUserName) Then
            Messagebox "Once submitted this document cannot be edited.", 64, "Help"
            Continue=False
      End If
End Sub


Although I am not saavy or experienced enough to know exactly how to write Lotus Script, I do know that this code locks down a form so that a user can not edit it once it leaves draft. However, an administrator like Sue Smith can.

I'd like to take this down to the field level so that instead of locking down the whole form,  I can lock down some fields, but leave others open for editing - such as the field that allows for attachments. Although we do not want the document edited once submitted, we do still want the user to be able to attach additional documentation.

Any suggestions would be much appreciated.
ASKER CERTIFIED SOLUTION
Jan Maritz
Solutions Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros