Event on clear button

[#1]

Hi,

I want to create an event on clear button. Whenever a user hits the clear button, I want the dashboard to select the first value in a field X. Kindly advise!

Thanks!

[Anonymous]

You want to put a trigger at "OnAnySelect".

The Action should be "Select in Field".  Enter your field name in the 'Field' box.

In the Search String enter somthing like

=if(isnull(GetCurrentSelections()),minstring(FieldName),)

If your field is numeric.  Only numbers, no leading zeroes you can use

=if(isnull(GetCurrentSelections()),min(FieldName),)

but if you have letters in the field values you'll have to use

=if(isnull(GetCurrentSelections()),minstring(FieldName),)

The difference being min vs minstring.

[Sergey_Shuklin]

Hello, Ahmed!

You can do this with variable and GetCurrentSelections() function.

See the attachement below.

There is a trigger on variable change.

[Anonymous]

You can do it this way too.