Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Hello, Ahmed!
You can do this with variable and GetCurrentSelections() function.
See the attachement below.
There is a trigger on variable change.
You can do it this way too.