Regarding Scheduled Report

Appu2
Tera Contributor

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!

2 REPLIES 2

Sohail Khilji
Kilo Patron
Kilo Patron

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....

LinkedIn - Lets Connect

Appu2
Tera Contributor

This script will give me all the months for which report is generated?

var month = ObjDate.getMonthUTC();