Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
i've a little problem this morning and, i'm not able to resolve it since two days.
On a simple liste box selection I just want to display 3 values.
This listbow selection is composed of 12 possible values.
For example :
I create a listbox slection named "month" wich is composed by the 12 month of year, and I want to only display the month : " march, april and may", even if the other month could be selected.
thanks for helping
Use the following expression in the listbox:
if(WildMatch(Month,'Mar', 'Apr', 'May'), Month)
Note that calculated dimensions like this affect performance. Better to create a new calculated field in the script.
Use the following expression in the listbox:
if(WildMatch(Month,'Mar', 'Apr', 'May'), Month)
Note that calculated dimensions like this affect performance. Better to create a new calculated field in the script.
Thx everybody
fast, clear , perfect
One of the many ways to do it is to have an expression in the list box:
=if(Match(Month,'Mar', 'Apr', 'May'), Month)
Or you can also use
=If(Month='Mar' or Month = 'Apr' or Month = 'Nov', Month)
But using such calculations may affect performance in some cases, so its always to do these things in script.
Hope this helps!