Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Wondering if anyone can help, I am using an expression = if(WildMatch(Function,'Group'),1,0) in a variable that I am using to show/hide another object.
"Function" is the value that is currently being used in a listbox, problem is that when I make other selections, e.g. 'Group' + 'Other', the resulting expression will be evaluated ad 0, as opposed to 1 if I select 'Group' alone!
Is there a way of saying, if Group IS FOUND IN or CONTAINS, then 1,0?
Thanks Community
Peter
Try this:
=If(SubStringCount(Concat(DISTINCT Function, '|'), 'Group') = 1, 1, 0)
Try this:
=If(SubStringCount(Concat(DISTINCT Function, '|'), 'Group') = 1, 1, 0)
Wildmatch or Match only works in only one value in the field, So you can use substringcount or Only functions to get desired result.
Thanks Sunny
I joined the two equations together, this worked well. Thanks for the tip though, will be very usefull for future projects.
if(WildMatch(GetCurrentSelections(Function),'*Group*'),1,0)
Thanks again Sunny
Peter
No problem.
If you got what you were looking for, please close the thread down by selecting correct and helpful answers.
Best,
Sunny