Send report Assigne To by Mail

[aruscitti]

Dear All,

I have created a report that lists all tasks that are open and assigned to specific users.

This report displays all currently open tasks. I need to modify the report as follows: 

• Highlight in red all tasks that have not been updated in more than 7 days.
• Send the report to the relevant individuals every Monday. Thank you!

[Dr Atul G- LNG · Accepted solution]

HI @aruscitti 

https://www.servicenow.com/community/platform-analytics-forum/how-to-send-weekly-scheduled-report-no...

https://www.servicenow.com/community/platform-analytics-articles/scheduling-a-report-for-dynamic-rec...

https://www.servicenow.com/community/developer-forum/can-scheduled-reports-send-personal-summaries/m...

[Shivalika]

Hello @aruscitti 

I see the report is already built by you so please follow below steps for highlighting - 

1)Go to the Style tab in the report editor.

2)Locate the Conditional Formatting section.

3)Click Add Condition:

Field: Updated

Operator: Before

Value: javascript:gs.daysAgoStart(7)

Color: Choose Red (or any warning color).

Save the condition.

Now, for sending the email every Monday, that you can do scheduled email generation of report. You can set the subject line, time and everything as per your requirement. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

Regards, 

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[aruscitti]

Hi Kilo

I tried but the colour did not work.

[Dr Atul G- LNG]

Hi @aruscitti 

Could you please check the OOTB field style , i think the syntax are wring in style