Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please Help
Hi,
Have a look at attached application.
Regards
ASHFAQ
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
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.