Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey ,
I have used a variable in charts/table as a field., So I want to add trigger ,whenever I click in any value of the field, it must redirect to another sheet .
I wass thinking of using a function on (get field selection(vSum)>0 ) by going in Settings<document properties<triggers
Could u guys please help me out?
Add an Activate Sheet action to the OnSelect field trigger of the field you make a selection in.
As i mentioned, i want to put trigger on expression fields(calculated fields) of charts, So i cant use "on select FIeld".
hence i created variables for the expressions cz variables have triggers on them too.
I tried using setting the value of a new variable, say vSelect which i can use in SHOW SHEET CONDITIONAL, using the exprssion =if(GetSelectedCount(vSelect) >0,1,0) .
but value of variable is not changing, its just 0 all the time.
But its not working.
Selecting a value in an expression column will select the dimension values on the same row. So you still need to use a field trigger. There are no triggers for expression values since they can't be selected in the first place.
but I cant use dimensions, they are being used in other tabs n chanrts also..i has to be chart and field specific.