Forum Discussion
Helper IIIRLS - Help needed to a newbie
gazzo1967 So why not just:
[Office] = "Sheldon Fire Station - Blue"
Then just add the watch commander and crew commanders only to that role.
Helper IIIGreg_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?
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
gazzo1967 So why not just:
[Office] = "Sheldon Fire Station - Blue"
Then just add the watch commander and crew commanders only to that role.