Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i set trigger in "Document Event Triggers" in action - "OnOpen", actions:
"set variable" and "activate sheet"
when i clicking on button - "Turn On/Off Webview" in app panel - it always open my sheet i've used in trigger
why ? i don't reopen document, only use a simple funtion (
i use SV 11.20 SR5 (build 12235) & win8
Hi,
I didn't see any triggers or variables in your attached document. Can you check?
regards.
siva
reload, i'll update file
Hi,
it always open my sheet i've used in trigger
why ? because you set active sheet onpen as SH02
In your Trigger
First you are setting the Variable (Set variable) and getting the selected sheet ID Say for example SH01
In Second step Active sheet you are Hard coded as SH02.. Do you want to set the value of the varible to the Active sheet trigger?
then in Active sheet you have to call that variable value like this..
=$(vLastSheet)
Selva
It appears that toggling back out of webview re-drives the open logic. Since switching is a development activity, I think you're unlikely to get anyone to consider this a bug -- vs a behavior.
-Rob
I also thought that the developers will find it in detail.
but still, Rob, you can write to them about this?
I'll create 2 trigger, because i think it have another bug,
try, create doc, on trigger OnOpen create 2 actions:
1. Activate any Sheet
2. set any variable value = GetActiveSheetId()
i think, true, in 2 step must be ID of sheet i've used in step 1,
no ?