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