Hide the Submit Button based on Multiple conditions

[golfnutt82]

Hello,
I have two Yes/No fields
I have part of the issue solved where I can show the Submit button if either Yes/No field is true but I am not able to hide the Submit button if both Yes/No fields are true.
I also have a label that shows when both Yes/No fields are true.

In the buttons Visible property I have the following: 

I even tried this without success:

[RandyHayes]

@golfnutt82 

Your Visible property is using an OR, meaning that if either one is true, then the control will be visible.  As I understand you, you want it to be visible only if both are true.

Please consider changing your Visible Formula to the following:

DataCardValue8.Value && DataCardValue9.Value

You don't need all the redundant true's and false's in the formula or the If statement.  The above will evaluate to either true or false already - which is all that is needed.

I hope this is helpful for you.

[RandyHayes · Accepted solution]

@golfnutt82 

Also, just re-read - perhaps you are saying you want it hidden if both are true.

If so, then change the formula to:

!(DataCardValue8.Value && DataCardValue9.Value)

[golfnutt82]

Hi Randy,
This worked.
Thank you again for a learning experience.
Why the !() vs. not using it in your first example? They look to be the same expect for the exclamation point and parens.

[RandyHayes]

@golfnutt82 

The ! is a NOT function.  The parens around it are so that we perform the logical AND and then take the NOT of that.

So, breaking the Boolean out.

For : DataCardValue8.Value && DataCardValue9.Value

DataCardValue8	DataCardValue9	Result (Visible)
false	false	false
true	false	false
false	true	false
true	true	true

For : !(DataCardValue8.Value && DataCardValue9.Value)

DataCardValue8	DataCardValue9	Result (Visible)
false	false	true
true	false	true
false	true	true
true	true	false

You can see in the last on, the results are just the logical NOT of the first table.

[golfnutt82]

Very awesome!
Thanks again!