Adding Select in Field to trigger in Sheet - nothing happens..

[hansdevr]

Hi everyone,

I want to add two triggered actions upon activating a Worksheet. The first is to Clear All and the second is to automatically select the current Registration Year (Jaar registr.). I tried all sorts of ways to achieve this (see picture above) but it just won't work...

What am I doing wrong?!?

[hansdevr]

Anyone willing to help me out here?!?

[prasadcm]

Can u provide qvw,so that it will be easier to get an solution

[jerrysvensson · Accepted solution]

If you use WebView (Ajax) as client, OnActivateSheet doesn't work.

You can use buttons or Actions on text objects instead to change sheet and apply triggers.

[Chanty4u]

can u remove "=" symbol in Filed  and try?

[hansdevr]

Hi Jerry,

Thanks for your reply!

This seems like the most logical conclusion, because I've tried anything else already. Is there a simple way to check if I'm using Ajax?

[hansdevr]

Hi Chanty,

Been there, tried that... Nope...

[Digvijay_Singh]

Try one trigger at a time, see which one is not working. Also try with constant year value, to know if something is wrong with syntax. also I think '=' before fieldname is not needed.

I tried like below and it worked for me -

[Chanty4u]

for me its wrked u can try with other select in field trigger or give the exact field name.

[hansdevr]

Hi Digvijay,

The 'Clear All' does work. I'll try your other suggestions. Thnx!