Discussions

Expand all | Collapse all

Control ROLE views based on a single reference field for entire app?

  • 1.  Control ROLE views based on a single reference field for entire app?

    Top
    Contributor
    Posted 06-17-2017 17:25
    I have an app with is built with a bunch of tables that is to serve 2 teams->Team 1 and Team 2.  Within one of my tables is a field, OPCO, that acts as a key to filter whether a project is controlled by Team 1 or Team 2.

    My idea is to control the user's access based on which Team # they are on.  I see that in Manage Roles I can create a custom rule that would limit a view, but since the field OPCO is not in every table, then this doesn't seem like the best option to use.

    I can put the field OPCO in all tables in the app and make them Lookup to the correct field, but that seems like a lot of work for something that should be a simple thing.  

    I looked through the posts and see answers that are close to what I need, but since I am basing this on a single field in one table inside the app, nothing really clicked.

    Thanks as always for the help.


  • 2.  RE: Control ROLE views based on a single reference field for entire app?

    Top
    Contributor
    Posted 06-19-2017 12:08
    Any particular reason you don't have 2 different roles and then apply the filtering across the entire app?


  • 3.  RE: Control ROLE views based on a single reference field for entire app?

    Top
    Contributor
    Posted 06-19-2017 15:18
    I will try that.
    Thanks.