OnOpen Triggers not working

james — Tue, 02 Feb 2016 21:11:39 GMT

All I have 7 items on a trigger on open, and they seem to not work.... Is there a maximum number that is preferred?

Re: OnOpen Triggers not working

sunny_talwar — Tue, 02 Feb 2016 21:15:12 GMT

I am not aware of max number of triggers. Are they may be conflicting each other for some reason? Can you share a sample?

james — Tue, 02 Feb 2016 21:23:10 GMT

OnOpen

1 Unlock and Clear all

2 Select in field Date =MaxString({$<Date={"=$(=vMaxDateTrigger)"}>}Date)

3 Select in field sAMAccountName =upper(SubField(OSUser(),'\',2))

4 Select Possible GroupName

Than group Name has an on activate trigger that sets a variable

vAD_GROUP_USW		=if(GroupName= 'Qlikview US W',if( WildMatch(GetFieldSelections(sAMAccountName),upper(SubField(OSUser(),'\',2))),1,0),0)
vAD_GROUP_USE		=if(GroupName= 'Qlikview US E', if(WildMatch(GetFieldSelections(sAMAccountName), upper(SubField(OSUser(),'\',2))),1,0),0)
vAD_GROUP_GLOBAL		=if(GroupName= 'Qlikview Global', if(WildMatch(GetFieldSelections(sAMAccountName), upper(SubField(OSUser(),'\',2))),1,0),0)

5 Select in Field Region = vRegion

6 Activate Sheet = v Sheet