Not applicable

Weekly Summary of Calendar Entries

Hi All,

My task is as follows: I have a list of calendar entries which could be anywhere from one day to a few weeks long.  Each Friday I have to send a summary of the calendar to a manager.  The summary must contain only the entries relevant to the current week - Monday through the Friday on which I send it.  If an entry overlaps between two weeks, I only send the half that is relevant (e.g. an entry from Thursday to the following Wednesday is sent as half in one week and half in the next week).  I imagine it is possible to automate this process through a workflow.

I am fairly new to Nintex so there may be an obvious solution that I am missing.  I only have access to the SP web editor with Nintex; no designer, visual studio, etc.

Thanks for the help!

Reply
2 Replies
melissac
Apprentice

Re: Weekly Summary of Calendar Entries

Hi Elliot,

Any progress on this?

I think this maybe done. you will need to calculate the End of the Week and then query the list.  Not a great suggestion but hopefully its a start.

0 Kudos
Reply
Not applicable

Re: Weekly Summary of Calendar Entries

Hi Melissa,

I solved my problem by doing the following. First, I broke each calendar entry up into a separate entry for each day (e.g. a Mon-Fri entry becomes 5 separate entries Mon, Tue, . . . Fri). Next I used a view to filter only entries where the date was between [TODAY] and [TODAY - 5]. Rather than send an actual report document to my manager, I just scheduled a site workflow to send a link to this view every Friday.

0 Kudos
Reply