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

[awhitfield]

Hi ajay

you don't need the quotes, just  (Austria|Benelux|Denmark) , gives:

HTH

Andy

[maxgro]

if you have some space

("Austria"|"Italy"|"Great Britain")

[santhoo_san]

You create a mapping field for these countries and take that Mapping field in your trigger

Sheet Properties ---> Triggers----- > select in field --- > Field = GrpCountry , search string = 'Group'

Country	GrpCountry
Austria	Group
Benelux	Group
Denmark	Group
Dubai	Group
Finland	Group
France	Group
Germany	Group
Great Britain
Hungary	Group
Italy	Group
Norway	Group
Pan-Europe (CP)
Poland	Group
Portugal	Group
Slovakia	Group
South Africa	Group
Spain	Group
Sweden	Group
Switzerland	Group

Hope this help.

[ajaykumar1]

Thanks Massiomo.Its working fine.

In addition with that i have the below scenario need to develop.

Condition 1 : If the Country not contains SWEDEN and DENMARK then mail should go to  DEVTEAM@xyz.com

Condtion  2 : If FLAG =0 then the mail to go  SALESTEAM@xyz.com

Condition 3 : If above two cases failed then SUPPORT@xyz.com

NOTE 1 : ALL the above conditions based on the MAX DATE selection.

2: Here i choosen select all option in triggers because to show all countries data in the straight table.

WHAT I TRIED :

= if(not wildmatch(Country,'Sweden','Germany'),'DEVTEAM@xyz.com',

if(flag=0,'SALESTEAM@xyz.com','SUPPORTTEAM@xyz.com'))

Please correct me where am wrong and also guide if in case its better to create a new thread.

MORE THANKS,

AJAY

[maxgro]

I think the 2 expressions are

number of country Sweden or Germany (for max date); it should be 0 for not Germany and not Sweden

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

value of the flag (for max date)

= only({$ <date={"$(=date(max(date),'DD-MM-YYYY'))"}>} flag)

EDIT: new thread?

yes, I think 1 thread, 1 question (maybe with a link to this) or for many questions, all questions at the start of discussion

[ajaykumar1]

Hi Massimo,

I dont want to do any count or sum...whatever the conditions 3 i need to combine at one level like if else.

As per the selection and condition satifisfaction data to be display in text box like whether its devteam or supportteam or salesteam.

thanks,

Ajay

[maxgro]

=

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

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

'SUPPORTTEAM@xyz.com'))

[ajaykumar1]

Thanks you.

I will try to apply the above logic with my original data scenario and will mark the thread.

Thanks,

AJAY

[ajaykumar1]

Hi Massimo...No luck its not working.

The same has been attached here.

Need help in the sample also my requirement is there.

More Thanks,

Ajay