Forum Discussion

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
3 years ago
Solved

RLS - Help needed to a newbie

HI all I need some help/direction with RLS. I would like to create a role. I need users (who are managers) from my User Information list who login in to do the following:-   If their [Jobtitle] ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    gazzo1967 So why not just:

    [Office] = "Sheldon Fire Station - Blue"

     

    Then just add the watch commander and crew commanders only to that role.

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
3 years ago

Greg_Deckler 
Thank you for replying 🙂
I did that and all it shows me is the two job titles but i need those two roles to be able to see the jobtitle Firefighter Sheldon too.

Basically if the Watch Commander or the Crew Commander login they should be able to see everyone who has the 'office' Sheldon Fire Station - Blue
But doing this only shows those 2 roles.
Sorry if i am coming across a little slow 😞
Gary

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
3 years ago

Greg_Deckler 
Sorry will try explain a little more clearly.
If the user logs in and has the [Jobtitle] of either Watch Commander A Sheldon or Crew Commander Sheldon then they need to see all rows with the [Office] = Sheldon Fire Station - Blue.
Can this be done with an IF statement?

  • gazzo1967's avatar
    gazzo1967
    Icon for Helper III rankHelper III
    3 years ago

    OK i got this far 🙂

    if([JobTitle] = "Watch Commander B Sheldon" ||[JobTitle] = "Crew Commander Sheldon",

    TRUE(), [Office]="Sheldon Fire Station - Blue" )

     

    This returns the following

    JobTitleOffice  
    Watch Commander B SheldonSheldon Fire Station - White
    Crew Commander SheldonSheldon Fire Station - Red
    Crew Commander SheldonSheldon Fire Station - Red
    Watch Commander B SheldonSheldon Fire Station - Red
    Crew Commander SheldonSheldon Fire Station - Green
    Watch Commander B SheldonSheldon Fire Station - Green
    Crew Commander SheldonSheldon Fire Station - Blue
    Crew Commander SheldonSheldon Fire Station - Blue
    Firefighter SheldonSheldon Fire Station - Blue
    Firefighter SheldonSheldon Fire Station - Blue
    Firefighter SheldonSheldon Fire Station - Blue
    Firefighter SheldonSheldon Fire Station - Blue
    Firefighter SheldonSheldon Fire Station - Blue
    Watch Commander B SheldonSheldon Fire Station - Blue

     

    All I need to do is exclude the entries that are not [Office]Sheldon Fire Station - Blue

    Again thanks for the help 🙂

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      gazzo1967 So why not just:

      [Office] = "Sheldon Fire Station - Blue"

       

      Then just add the watch commander and crew commanders only to that role.