Solved

Edit role

Posted on 2001-06-14
4
192 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
[X]
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
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

623 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