Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Form Level Security

Posted on 2003-11-14
Medium Priority
Last Modified: 2013-12-18
Hi all, i have a form which multiple people fill out. Rather than have a different view for each person so they can not see each others forms, how could i have just 1 view and the people would see only forms they submitted. Basically is there a way on the form i can say who ever orginally created this and the admin role can see this particular document, but no one else can.

Jason Incarnato
Question by:unknown45
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 31

Expert Comment

ID: 9750377
Add two COMPUTED WHEN COMPOSED readers names field, with the following formulas:

1: @UserName
2: "[Administrator"

(For #2, ths would be to allow reading by anyone that has an ACL role of Administrator.)
LVL 24

Expert Comment

ID: 9750451
Setting up the readers field is the way to go. Not necessarily two fields a single field with multi values will do.

The formula should be like this

@Unique(DocReaders : @UserName : "[AdminRole]")

Second consideration that might have to be taken care would be to Enable "Don't show categories having zero documents" if you have categorized column in the view. This setting is available in Views property .. Advanced tab.

LVL 31

Expert Comment

ID: 9750467

I like two fields because of all the times I've seen people forget to check off "allow multiple values," and then nobody has access.  I've seen top dog Notes guys get themselves in a bind this way!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 24

Expert Comment

ID: 9750508
I agree, But there were situations where people forgot the existence of other readers/authors field and get into trouble.

Author Comment

ID: 9750524
I have everyone listed in the access control list of the database and most of them have over reader rights, so then all of them would be able to access this document. If i remove them from the database ACL list then they couldn't access the form correct?
LVL 31

Accepted Solution

qwaletee earned 2000 total points
ID: 9750616
I'm not sure what you just said, very confusing language.

Readers fields are an optional setting on documents that restricts who can see the document.  No reader field (or all blank reader fields) provide no restriction.  Adding a readers fields means that only those listed in teh readers field (or the combination of people listed in multiple reads fields) will get to see the document, regardless of ACL settings.  So, the readers field has nothing to do with ACL reader access, or acl author access, or acl manager, etc.

Author fields are different.  They allow "editor" access to a particular document for someone listed in the ACL as Author; otherwise, that person is treated as a reader of the document.  (In addition, the Author field overrides reader restrictions - an author is always treated as a reader, even if not explicitly listed in a reader field.  if there are no reader fields, or only blank reader fields, this does not apply, as there are no reader restrictions there anyway.)

If you are not listed in the ACL at all, then default access applies to the user.

I will reiterate on point: If you are listed in ACL as a reader, but there is a document with a readers field in it, then you will NOT be able to read that document unless you are also in teh reader field for that document. Reader access has NOTHING to do with reader fields.

Author Comment

ID: 9750649
Thanks, Qwaletee. Yes I guess I didn't express myself very clearly but you did a good job a deciphering it!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question