Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi Bill,
Try this expression as the show condition:
Wildmatch(GetFieldSelections([BM STAFF],'|')'Ancillary')
Cheers
Andrew
Go to button properties->Layout ->Conditional, put below expression
=if(match([BM STAFF],'Ancillary'),1,0)
Hi Bill
=count(distinct if(MyField='x',0))
Thanks, However it needs to have the condition that if "Ancillary' is not selected it wont show. This is for any selection. Thoughts?
Andrew it is showing even if nothing or something is selected. Thoughts?
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.
Fer Fer this worked perfectly. Thanks!!
Try this
=if(wildmatch(concat(distinct [BM STAFF], ',') ,'*Ancillary*'),1,0)