alert mail or alert error

[Anonymous]

Hi..

I have an doubt please clarify me..

I have an table

Country,Sales two fields.daily I am fetching data from the data base for example My table looks like this

Country,Sales

USA,800

India,700

UK,900

Germany,500

Like this I am daily fetching data I want alert mail or alert error when any these country is goes to sales less than 200..?

how I want to make changes when I need this type of task..?

Thanks in Advance.

[kaushiknsolanki]

Hi,

    Go can go to alert wizard and there you can add the relevant information and create an alert.

    For more information you can also go to Help.

     Have a look at the application attached.  

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik,

Thanks for a REPLY,I want dynamic data you are mentioning country = India,if any other country goes to below threshold means there is no  alert message.

[kaushiknsolanki]

Hi Sara,

     That depends on the condition, you can modify the condition as you want.

     I took India just to show how it works.

Regards,

Kaushik Solanki

[Anonymous]

But its not working properly for me could you able to give some other solution for this..!!

Thanks in Advance.

[#6]

Using aggr() you can achieve...

Find revised file of kaushik..

Karthik

[tresB]

Sara,

See the attached sample.

[rajni_batra]

Hi Kartikeyan & Karthik,

I have learnt new thing today

If suppose i want like to pop up or mail list for those country having sales less than 200 along with data

how that can be done?

Regards,

Rajni

[#9]

By using tresesco solution you can find list of countries those are less than 200..

and you have to set smtp details on Settings --> User Preference --> Mail.

In alert you have to mention mail id and subject..

Thats all..

Karthik

[tresB]

Rajni,

PFA for what you want.