Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Long question on Calendar workflows and Calculated Values

  Asked By: Jefferson    Date: May 22    Category: Sharepoint    Views: 1892

We are creating a workflow in the Calendar for events. Here are the

1. Team Lead creates Event in the Calendar on CreationDate.
1a. The System needs to confirm that the leadtime for the event is 6
months for Category 1 events, 4 months for Category 2 events and 2
months for Category 3 events ELSE the event needs special approval
before being entered into the Calendar, where leadtime=Event

2. Once the event has been created, the workflow kicks in and send
an alert to Group 1 (consisting of 28 Department Representatives)
for feedback who have to respond within CreationDate+14.
2b. A reminder needs to be sent to those who don't respond within
The feedback from Group 1 will divide them into participating
Group1A and non-participating Group1B. Group 1A and Group 1B will be
different for different events.
3. The Team Lead then includes the participation level (1-3) of each
3b. The Team Lead manually sends out an Acknowledgement workflow to
Group 2B consisting of Heads of non-participating Divisions.
3c. The Team Lead manually sends out an Approval workflow to Group
2A consisting of Heads of participating Divisions.
4. On approval, the event appears in the calendar.
5. After the event, the system must automatically send out a
reminder on EndDate to the TeamLead and Group 1A to raise a Closure
Report before EndDate+7.
5a. Before EndDate+7, the TeamLead must fill field "Closure Report
sent out" as "Yes" ELSE system will send out alert to Group 2A.

Questions per numbering above:
1b. Can the system check that StartDate-CreationDate falls within
the 3 categories ELSE prevent the Event from being entered without
special approval?
2b. Can reminders be sent specifically to those who don't respond?
Is there a calculated value for CreationDate+7?
3b & 3c. Can the distribution lists for Groups 2A and 2B be
automatically generated taking into account that they are different
for different events?
5. Can system automatically send out a reminder on EndDate?
5b. Can the system send out an alert to Group 2A on EndDate+7
IF "ClosureReportSentOut" is not equal to "Yes"?

That's a lot of questions. Hope someone familiar with MOSS2007 can
help. Note that I have used "the system" to denote MOSS2007.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Long question on Calendar workflows and Calculated Values Or get search suggestion and latest updates.