Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to trigger a set of events when the variable is equal to 1.
say when an user is on tab 1 and selected 'open sesame ' and only this value in field X, I want to apply a series actions happen
otherwise don't do anything. so I create a variable name vAction=if(X='open sesame' and getactivesheetid()='document\SH1',1,0)
how do I trigger events based on variable vAction. I don't want to trigger it upon change:1) doesn't work in Ajax and all my users are Ajax; 2)if the variable change from 0 to 1, action happen--> good; 1 to 0, action happen-->not good.
How do I get action to happen only when vAction=1?
Thanks
In case of OnChange trigger (I read that you don't want to use it but...) you can try to use another variable with action and with this variable just set value with condition for the second variable
IF(vAction=1,1,vSecondVariable)
im trying to understand how to implement this. say vAction=0, vSecondVariable=?
So, I played a bit with this staff...
PFA
I just added conditions to the triggers