AnsweredAssumed Answered

Hide Object When Calculation…

Question asked by lourensjoubert on Apr 7, 2018
Latest reply on Apr 9, 2018 by lourensjoubert

Hi Forum Gurus… where am I going wrong?

 

Layout has two fields (both on same table):

  • JobStatus: Can be one of nine predefined values (populated by selecting a value from a static value list), e.g. Assigned, Pending, Other…
  • JobAssignedTo: A team member (populated by means of a dynamic value list)

 

Currently the JobsAssignedTo field is hidden on the layout, except when the JobStatus field is ‘Assigned’.

Screen Shot 2018-04-07 at 10.34.32.png

This works as expected.

 

I’d like to also not hide the JobAssignedTo field with a second and third value in the Job Status field. I’ve tried the below functions, but my logic must be flawed, because they  hide everything.

 

Function1

Job::JobStatus ≠ "Assigned"  or

Job::JobStatus  ≠ "Other"

 

Function2

Case (

Job::JobStatus  ≠  "Assigned"; 1;

Job::JobStatus  ≠ "Other";1;

0)

 

Function 3

If (

Job::JobStatus ≠ "Assigned" or

Job::JobStatus  ≠ "2B Quoted";

1)

 

Any pointers?

Outcomes