?
Solved

Edit role

Posted on 2001-06-14
4
Medium Priority
?
196 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 150 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

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