Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Edit role

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

972 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