We help IT Professionals succeed at work.
Get Started

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

fselliott asked
Last Modified: 2013-12-18
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"
      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.
Watch Question
Solutions Analyst
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE