Trigger Selected Fields won't clear

[Anonymous]

Hi All,

I searched a few times for an answer for this, since it seems like I'm missing something simple.

I have a field [SliderOptions] that I use for a slider, from that a trigger selects options in [Score]. The trigger select is:

='(' & Concat(DISTINCT [SliderOptions], '|') & ')'

The problem is, when I make a selection on the slider and then hit 'clear' at the top, the [SliderOptions] clear but the [Score] selects everything. Can someone help me determine why? And a way to make the clear work in this format?

I've attached a sample.

Note: hitting clear twice will clear everything, I know, but I'd like it to do it the first time.

Thanks!

[krishnacbe · Accepted solution]

Try below expression in your trigger.

=if(GetSelectedCount(SliderOptions)>=1, '(' & Concat(DISTINCT [SliderOptions], '|') & ')')

[Anonymous]

This works! Thank you!

[YoussefBelloum]

Hi,

Just added a condition on the Trigger to check if the Slider Is null

check attached