Solved

Edit role

Posted on 2001-06-14
4
189 Views
Last Modified: 2013-12-18
I have a registration database and have a spot for status on the account.  I need a formula that will allow people part of BCO role editable access to the section.  People not associated with the BCO role will be able to see but not edit the section.  I just need the forumula and if you have any further questions please feel free to contact me at samir_6@hotmail.com

Thanks!
0
Comment
Question by:SamirKumar
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 50 total points
ID: 6193431
If you are dealing with only one field then create two fields one editable and other just display and hide depending upon the role

Formulat to test the role is

@ismember("[Admin]"; @UserRoles)

If you are dealing with lots of fields then group them under one section and use the same formula as above in the Formula tab and make it computed for display

Let me know of any specifics !

~Hemanth
0
 
LVL 13

Expert Comment

by:CRAK
ID: 6194160
Create a "Controlled Access Section".
Type: "Computed"
Formula: "[BCO]"
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6195395
Sorry I din't mention "Controlled Access" for the section.

And Crak was correct about the formula. You should mention the role name like "[Admin]" as the formula.

0
 
LVL 5

Expert Comment

by:snocross
ID: 6196491
Another way I do this is to have multiple copies of each field.  An editable copy and a computed (or read only) copy.  Then hide the appropriate field based on the user.

For example I might have a field called status that is editable.  I will also have a second field called status2 that is computed to equal the status field.  Then I use a simple hide-when formula to toggle between the two fields based on the access level of the user.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Email relaying to outside address 4 170
How to automate deletion of content in Lotus Notes mailboxes 3 223
Text over two lines in VBA for email 26 165
Lotus Domino 9 web server 6 93
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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