Send Mail/Alert to users

[#1]

Hello Everybody,

I am trying to send an email alert on the refresh of the dashboard to the users who have not filled their time sheet .

I found couple of posts in this community on how to make email alert/send mail.

I want to know how I will proceed with that means what Condition I will put in the Alert Tab-> condition

and do I have to write all the user's mail id(those who have not filled their Time sheet) under the mail recipients or I have to create any variable for that?

Please help..

Thanks in Advance
Sonali

Message was edited by: Sonali Singh

[#2]

Please Help

[ashfaq_haseeb]

Hi,

Have a look at attached application.

Regards

ASHFAQ

[#4]

Hi Ashfaq,

Thanks for your reply.

I understood the functionality of Alert Tab but my requirement is user should get one mail alert those who have not filled time sheet.

I don't want to hard coded the recipients it should go automatically those who have not filled time sheet. Like you have created  "EmailAlertTo" table, What I have to create?

And in the expression tab of Alert Wizard what Expression should I put so that if the condition will true then it will send alert.

I have attached my sample QVW.

Please have a look and Do Reply.

Many Thanks

[sudeepkm · Accepted solution]

create a table in your data model which will have the UsersEmail and TimeSheetFilledStatus.

in the Alert Email Recipients you can use something like below.

concat({<TimesheetFilledStatus={'NO'}>} UsersEmail,';')

The above expression will create a string capturing all those Users Emails where the users have not filled the time sheet.