Trigger Help

[ajaykumar1]

Hi Everyone,

If i enter into the sheet by default certain should be select mode always.For that i have done like below

Sheet Properties---Triggers---select in field---

I have the field country and the values are below.

Austria

Benelux

Denmark

Dubai

Finland

France

Germany

Great Britain

Hungary

Italy

Norway

Pan-Europe (CP)

Poland

Portugal

Slovakia

South Africa

Spain

Sweden

Switzerland

I tried like below :

'(Austria|Benelux|Denmark|Dubai|Finland|France|Germany|Hungary|Italy|Norway|Poland|Portugal|Slovakia|Spain|Sweden|Switzerland|*South*|*Great*|*Pan*|*Senegal*)' 

But its not working.I need to resolve this then i need to go ahead with further requirement.

More Thanks in advance,

Ajay

[ajaykumar1]

Hi ,

Any help or hint from anyone?

More Thanks,

Ajay

[maxgro]

Sweden and Germany ?

Sweden and Denmark ?

for Sweden and Germany change the expression (bold)

if(count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)=0, 'DEVTEAM@xyz.com',

if(only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)=0, 'SALESTEAM@xyz.com',

'SUPPORTTEAM@xyz.com'))

the result I get is

[ajaykumar1]

Thanks Massimo.Your right...Its my mistake and sorry for convenience caused earlier.

One thing i want to know how  =0  is working here?

What will happen if i kept <> 0 and if i remove the 0?

When am playing with original data with and without 0 am getting some wrong result.

More Thanks for your valueble support.

Ajay

[maxgro · Accepted solution]

if I understand

One thing i want to know how  =0  is working here?

It works as a standard if: if(condition,  then, else); condition could be true or false.

if(exp1=0,

     'DEVTEAM@xyz.com',                         // exp1=0

     if(exp2=0,                                              // exp1 not = 0

          'SALESTEAM@xyz.com',                    // exp2 = 0

          'SUPPORTTEAM@xyz.com'               // exp2 not = 0

     )

)

exp1 is the result of the below expression (add a textbox with this expression to see the result of exp1)

=count({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}, Country={Sweden,Germany}>} distinct Country)

exp1 is the number of distinct country for max date and with country = Sweden or Germany

when exp1 is 0  --> DEVTEAM

if(0=0,

     'DEVTEAM@xyz.com',                         // exp1=0

      ......