Forum Discussion
gazzo1967
Helper III
Helper IIIRLS - 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] ...
gazzo1967 So why not just:
[Office] = "Sheldon Fire Station - Blue"
Then just add the watch commander and crew commanders only to that role.
gazzo1967Helper III
Helper IIIOK i got this far 🙂
if([JobTitle] = "Watch Commander B Sheldon" ||[JobTitle] = "Crew Commander Sheldon",
TRUE(), [Office]="Sheldon Fire Station - Blue" )
This returns the following
| JobTitle | Office | ||
| Watch Commander B Sheldon | Sheldon Fire Station - White | ||
| Crew Commander Sheldon | Sheldon Fire Station - Red | ||
| Crew Commander Sheldon | Sheldon Fire Station - Red | ||
| Watch Commander B Sheldon | Sheldon Fire Station - Red | ||
| Crew Commander Sheldon | Sheldon Fire Station - Green | ||
| Watch Commander B Sheldon | Sheldon Fire Station - Green | ||
| Crew Commander Sheldon | Sheldon Fire Station - Blue | ||
| Crew Commander Sheldon | Sheldon Fire Station - Blue | ||
| Firefighter Sheldon | Sheldon Fire Station - Blue | ||
| Firefighter Sheldon | Sheldon Fire Station - Blue | ||
| Firefighter Sheldon | Sheldon Fire Station - Blue | ||
| Firefighter Sheldon | Sheldon Fire Station - Blue | ||
| Firefighter Sheldon | Sheldon Fire Station - Blue | ||
| Watch Commander B Sheldon | Sheldon 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
Community Champion
Community Championgazzo1967 So why not just:
[Office] = "Sheldon Fire Station - Blue"
Then just add the watch commander and crew commanders only to that role.