orbitpro

Hide Object based on three fields

Discussion created by orbitpro on Feb 26, 2018
Latest reply on Apr 13, 2018 by orbitpro

Hi,

 

I know this question has been asked and answered but I am really struggling to get my 'hide object' formula working.

 

I have a 'DEALS' table with three fields I am trying to reference to either hide or show an object.  These formula I am using is:

 

( DataFile_DEALS::Deal_ActiveStatus ≠ "Settled" )

and

( DataFile_DEALS::Income_Lender_ExGST = "" )

and

( DataFile_DEALS::Income_Lender_DatePaid ≠ "")

 

 

The logic I am aiming for is that the object needs to be hidden if the fields have the following conditions:

 

DataFile_DEALS::Deal_ActiveStatus does not contain the value "Settled" (this is a text field)

and

DataFile_DEALS::Income_Lender_ExGST does not contain a value (this is a number field)

and

DataFile_DEALS::Income_Lender_DatePaid contains a value (this is a date field)

 

 

Another way of wording the logic is to show the object when the values are as follows:

 

DataFile_DEALS::Deal_ActiveStatus is 'Settled"

and

DataFile_DEALS::Income_Lender_ExGST is not empty

and

DataFile_DEALS::Income_Lender_DatePaid is empty

 

 

How would I be able to hide the object based on the above?

 

Thanks in advance for any assistance

Outcomes