Create Dynamic schedule reports for Individuals base on Opened_by sc_req_items

Peter Williams
Kilo Sage

Good day everyone,

i have a tricky request, i need to schedule a weekly report for individual users with pending requests opened by them.

It should be only sent to them with any active request that hasnt been completed or closed

 

The condition on the report i created is as follows:

PeterWilliams_0-1732286561528.png

 

i need now to get the email address of the opened_by and populate that for the schedule report that will be sent out to the users that will have anything that is opened

 

PeterWilliams_1-1732286631469.png

 

0 REPLIES 0