Conditional Formatting logic

[Jesdamian]

As I understand it correctly, if you do conditional formatting, the formula equals either 1 or 0. That is, yes or no.

 

 

I have a tab I want to hide by changing the fill color to the background of the project.

 

I want to hide it if the person logged in belongs to the Auditor group. 

 

I can get the Privilege set with the  

 

Get ( AccountPrivilegeSetName ) = "Auditors"

 

 

But I'm not sure how to pass a yes or no to the formula.

 

IsValid doesnt seem to work

 

I also tried

 

 

If

Get ( AccountPrivilegeSetName ) = "Auditors"

Value=1

 

but that just produces errors.

 

 

 

What would yall recommend I use to get the privilege set of the person logged in and pass a true value to trigger conditional formatting?

 

 

 

[bcooney]

You should be able to simply put in the formula bar, Get (AccountPrivilegeSetName) = "Auditors"

 

which evaluates to true (remember, you need to login with an account belonging to that priv set to see it work). Also, confirm that is the exact name of the privilege set.

[Jesdamian]

hmm.. in that case I'm running into a different issue since the fomatting is not changing for auditors. Thanks for the confirmation that I'm technically going about it the right way.

[Jesdamian]

a little more if people are interested. I"m using IWP for people in the field.  through IWP the coniditional formatting does not appear. The tab is there and clickable. However, through the ipad client or Filemaker Pro, conditional formatting is done. 

 

so I guess I was doing it right but I didnt test it under the right condition. since my auditors are going to need to use IWP, I have to figure that part out now

[bcooney]

Put Get (AccountPrivilegeSetName) in the data viewer to confirm it has the value you assume it has.