on open trigger

[kunkumnaveen]

Hi

in the  trigger  ON OPEN

i wrote= max(year) and max(year,2) and max(year,3)

which should select max 3 yr on open...but its not working

thanks

naveen

[Kushal_Chawda · Accepted solution]

Try to change the trigger condition like below

[martinpohl]

For multi selection you need a '|' between values and brackets around

='('&max(Year)&'|'&(max(Year)-1)&'|'&(max(Year)-2)&')'

Regards