Select in Field (just once - on open application)

[chriys1337]

Hi,

I am using currently Select in Field Trigger to pre-select two selections on one tab. But when I am jumping through my (3) tabs and go back to tab nr1, it is again selecting the predefined selections.

Is it also possible to "just once" select the given selections with a Trigger?

Kind Regards,

Chris

[ali_hijazi]

you can take advantage of the OnOpen trigger (at the document level)

on this trigger select the desired sheet and add the select in field

this will happen only on opening the document for the first time

but keep in mind that this trigger only works if the document is open in server using IE browser with IE-plug in installed

it doesn't work with other browsers like chrome or firefox (here I'm assuming the document is being opened from the access point)

or you can add a conditional action on the OnActivate Trigger of the sheet

if(condition, then select in field)

condition could  be a variable that at the beginning contains a value and once the sheet is activated it is set to another value and so on the second and successive activation of the sheet ,selection in field is not applied

[tresesco]

PFA

Check the following triggers:

• OnOpen (Variable value setting)
• OnActivateSheet (Conditional trigger)

[tresesco]

There is some issue, not allowing me to attach

[chriys1337]

Hi,

thanks for your reply. Unfortunately the IE plugin is not supported anymore and we are using Ajax.

What if I use the on open trigger in combination with Ajax?

Any ideas?

[ali_hijazi]

the onOpen trigger doesn't work in Ajax