Forum Discussion

ChuckHardy's avatar
ChuckHardy
Qrew Member
4 months ago
Solved

Managing record access for multiple data levels

Hi -- I'm attempting to update access permissions to an existing table which has Records according to 4 different Teams (Team A, B, C, D)  where Team is a field associated with each record.   Each re...
  • MarkShnier__You's avatar
    4 months ago

    I'm think you need a formula checkbox field as a helper field, called [OK to Show Confidential Section?]

    There is a function called UserRoles("ID")

    which returns a text list of all the role numbers the current user is in  

    You get the two digit Role number by viewing the role and observing the URL string  

    The formula would be something like this

    (Contains(UserRoles("ID"), "12") and [Team]= "Team A")

    or 

    )Contains(UserRoles("ID"), "13" and [Team]= "Team B")

    etc for the next 2 Teams.   



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------