Need to hide a field base on JobTitle

Like (0) Share

Report

Posted on 29 Apr 2024 18:46:04 by Jambou

I have a "RequestorJobTitle" text field that looks up the current user's Job Title using this formula:

First(Office365Users.SearchUser({searchTerm:txtRequestor.Selected.Email}).JobTitle)

This shows the users job title. Now I want to hide another field any time "RequestorJobTitle" contains the word "Manager", "Director", "Vice" or "Chief"

I've tried this:

If("Manager" in Office365Users.MyProfile().JobTitle, false, true Or If("Director" in Office365Users.MyProfile().JobTitle, false, true) Or If("Vice" in Office365Users.MyProfile().JobTitle, false, true) Or If("Chief" in Office365Users.MyProfile().JobTitle, false, true))

and:

If(Switch("Manager" in Office365Users.MyProfile().JobTitle, "Director" in Office365Users.MyProfile().JobTitle, "Vice" in Office365Users.MyProfile().JobTitle, "Chief" in Office365Users.MyProfile().JobTitle), false, true)

Which doesn't seem to work. What is the best way to do this?

All responses (6)

Answers (2)

Verified answer

Jambou on 29 Apr 2024 at 20:27:00

Like (0)

Report

Re: Need to hide a field base on JobTitle

Thank you @Gochix. This works perfectly! Thank you so much.
Verified answer

Gochix 1,933 Moderator on 29 Apr 2024 at 20:04:25

Like (0)

Report
Re: Need to hide a field base on JobTitle

@Jambou ,

use:
If( Or( !IsBlank(Find("Manager", RequestorJobTitle.Text)), !IsBlank(Find("Director", RequestorJobTitle.Text)), !IsBlank(Find("Vice", RequestorJobTitle.Text)), !IsBlank(Find("Chief", RequestorJobTitle.Text)) ),false,true)

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
Jambou on 29 Apr 2024 at 19:44:26

Like (0)

Report

Re: Need to hide a field base on JobTitle

Thank you @Amik ,

I tried adding this to the Visible property and it's doesn't work.
!Office365Users.MyProfile().JobTitle in [
"Manager",
"Director",
"Vice",
"Chief"
]
Jambou on 29 Apr 2024 at 19:42:54

Like (0)

Report

Re: Need to hide a field base on JobTitle

Hi @Gochix ,
I tried this and it works for "Manager" but how can I get it to work with the other values "Director", "Vice" and "Chief"?

I tried this and it does't work:
If(!IsBlank(Find("Manager",txtRequestorJobTitle.Text)),false,true Or !IsBlank(Find("Director",txtRequestorJobTitle.Text)),false,true Or !IsBlank(Find("Vice",txtRequestorJobTitle.Text)),false,true Or !IsBlank(Find("Chief",txtRequestorJobTitle.Text)),false,true)
Ami K 15,665 Super User 2024 Season 1 on 29 Apr 2024 at 19:37:14

Like (1)

Report
Re: Need to hide a field base on JobTitle

@Jambou - in addition to the solution from @Gochix, apply the below to the Visible property:

!Office365Users.MyProfile().JobTitle in [ "Manager", "Director" "Vice", "Chief" ]

Note the absence of the IF function. Given the Visible property only accepts a Boolean (true/false), there is no need to wrap an IF function around a formula which is already going to return a Boolean anyway.
Gochix 1,933 Moderator on 29 Apr 2024 at 19:21:09

Like (0)

Report
Re: Need to hide a field base on JobTitle

@Jambou ,

As you are mentioning that you want to hide another field if the RequestorJobTitle.Text contains specific word, then you don't have to filter through the Office365Users again, but rather the JobRequestorJobTitle.Text.
If(!IsBlank(Find("Manager",RequestorJobTitle.Text)),false,true)

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!