Visible Function: OR

[amypeach]

Hello

Complete newbie - please forgive me.

I've watched a YouTube video to make a data card visible when the user selects a particular option from another data card - using: DataCardValue4.Selected.Value = "P1"

I'd like the value to be something along the lines of DataCardValue4.Selected.Value = "P1" Or "P2" Or "P3" Or "P4"

Whilst there are no errors thrown, this just doesn't work.

How can I make it so that a user can select 1 of multiple options to make the next data card appear? (It is the same data card if that makes it any easier.)

For context, the 5th option is the one if chosen that I don't want the data card to appear.

Would it be easier to somehow make the formula DataCardValue4.Unselected.Value = "Not Raised" - appreciate "unselected" is not an actual term.

Any help would be amazing!

Thank you in advance!

[zmansuri]

DataCardValue4.Selected.Value <> "Not Raised"

[RandyHayes]

@amypeach 

You cannot OR the comparison values, you would need to OR the comparisons.

So, technically your formula should be:

DataCardValue4.Selected.Value = "P1" Or DataCardValue4.Selected.Value = "P2" Or DataCardValue4.Selected.Value = "P3" Or DataCardValue4.Selected.Value = "P4"

As you see, there are multiple comparisons that are OR'ed together.  Highlighting an individual comparison in blue above.  You then have 4 comparisons OR'ed together.

You formula can be shortened with the || operator, which is a shorthand for OR

DataCardValue4.Selected.Value = "P1" || DataCardValue4.Selected.Value = "P2" || DataCardValue4.Selected.Value = "P3" || DataCardValue4.Selected.Value = "P4"

And, all of it can be reduced down to:

DataCardValue4.Selected.Value in "P1|P2|P3|P4"

Note: the vertical bars are not significant to any syntax, they are just there to separate visually.

If you want to set by the inverse, then you can use this:

!(DataCardValue4.Selected.Value = "Not Raised")

This basically will make the Visible property true if anything EXCEPT "Not Raised" is selected.  Note the ! (not) operator in the formula.

I hope this is helpful for you.