AnsweredAssumed Answered

Hide Object When - Calculation with Get Found Records and Pattern Count Question

Question asked by lindseym on Jan 25, 2018
Latest reply on Jan 27, 2018 by beverly

Hello,


I have a layout that I want to show exceptions. I also have a script that navigates to the layout, and searches a custom field for "TBD", displays those exceptions, and then sorts by.

 

 

What I want:

 

I want to hide the column heading, when all found records contain the same text ( "N/A" - which I formatted green) , But not hidden when 1 or more "N/A" is present. Basically hiding the entire column if all records are (N/A)

 

 

 

What I Want: (The Green N/As will be hidden - but I can manage that )

 

 

 

What I get:

 

I've tried a few different calculations, but can't get it to consistently work.

( I removed the Hide object when from the fields as I was trying to figure it out)

 

What I thought would work the most is:

 

Hide Object When:

Get(FoundCount) = PatternCount ( Message Schedule::Phase C ; TextColor ( "N/A" ; RGB ( 0 ; 156 ; 0 ) ) )

 

So The Found count would be 3       and then patterncount would count 3 -- but as I type that... It's looking per row  - NOT per column. Is that my issue?

 

How do I get around it? I also, sometimes get confused with non zero  values are ture, zero and empty values are false (so I switched hte equals to not equals with now luck)

 

Thanks,

 

-L

Outcomes