Regarding Scheduled Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 12:27 AM
Hi,
I have created a conditional Scheduled Report to generate the report in every 3 months on every 1st day of the 3rd month.
Now the requirement is to show the months dynamically for which the report is generated in every 3 months on the Scheduled Report - Subject or anywhere in the report just to let them know for which months the report is for!
I don't know how to achieve it!
Any inputs are appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 12:41 AM - edited 03-06-2024 12:46 AM
Hi @Appu2 ,
You can create a mail script and call it in your report schedule/notification which will include the name of current month + its last 2 months.
let say, your scheduling the report to send every 3 months from now.
then current month will be March and the previous 2 months will be Jan & Feb.
Report subject > Jan Feb Mar ..... andso on....
[AND/OR]
Create an json value pair as
{
1:jan,
2:feb
3:mar
...etc...
}
//use this to get month:
var month = ObjDate.getMonthUTC();
i hope this helps...
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-06-2024 12:53 AM
This script will give me all the months for which report is generated?
var month = ObjDate.getMonthUTC();