Show Conditional if value 'X' field is selected

[billuran]

Hello, I have a button i want to show if value X is selected regardless if Y is selected as well. So show button if at least X is selected. here is actual formula which works if only 1 value is selected.

[BM STAFF]='Ancillary'

I am sure its an easy solution.

Bill

[vishsaggi]

Can you write an OR condition to show this. Can you share you actual expression where you are using this.

May be like this in your button conditional check expression

= IF(GetSelectedCount(YourfieldName) > 0, 1, 0)

[effinty2112]

Hi Bill,

          Try this expression as the show condition:

Wildmatch(GetFieldSelections([BM STAFF],'|')'Ancillary')

Cheers

Andrew

[Kushal_Chawda]

Go to button properties->Layout ->Conditional, put below expression

=if(match([BM STAFF],'Ancillary'),1,0)

[el_aprendiz111 · Accepted solution]

Hi Bill

=count(distinct if(MyField='x',0))

[billuran]

Thanks, However it needs to have the condition that if "Ancillary' is not selected it wont show. This is for any selection. Thoughts?

[billuran]

Andrew it is showing even if nothing or something is selected. Thoughts?

[billuran]

Thanks Kushal, However it is still hidden even if more then just Ancillary is selected. I want it shown if Ancillary is selected and if anything else selected aswell.

[billuran]

Fer Fer this worked perfectly. Thanks!!

[Kushal_Chawda]

Try this

=if(wildmatch(concat(distinct [BM STAFF], ',') ,'*Ancillary*'),1,0)