Edit role

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!
SamirKumarAsked:
Who is Participating?
 
HemanthaKumarCommented:
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
 
CRAKCommented:
Create a "Controlled Access Section".
Type: "Computed"
Formula: "[BCO]"
0
 
HemanthaKumarCommented:
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
 
snocrossCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.