I have set up a workflow in sharepoint with 3 branches 1.Event creation email
2. Event modification email 3. Event not updated in 2 days email. It all
works except number 3.
To trigger the email, I created a calculated field in share point "Modify
SLA" with is the modified date plus 2 days. In the brank it is If Modify SLA
< Today send the email.
To test this I set the Modify SLA to 15 minutes instead of 2 days to be sure
it will work and it doesn't. Am I being stupid here? Is there a better way?
My question would be this... what triggers the review of your Events
i.e. in #1 the action of creating a new Event causes the workflow to
trigger. In #2 the action of modifying an event causes the workflow to
trigger, but in #3, you're depending on nothing to trigger the
comparison of time that would trigger the workflow i.e. you're depending
on *inaction* to trigger the process. Inaction cannot trigger a process
so do you have some kind of service running that does the comparisons
and kicks off the workflow?
"Norm ("I know nothing")" <NormIknownothing@discussions.microsoft.com>
wrote in message
news:D064C1C0-BEB9-4384-87FE-833B7FCDAC3A@microsoft.com:
> I have set up a workflow in sharepoint with 3 branches 1.Event creation email
> 2. Event modification email 3. Event not updated in 2 days email. It all
> works except number 3.
> To trigger the email, I created a calculated field in share point "Modify
> SLA" with is the modified date plus 2 days. In the brank it is If Modify SLA
> < Today send the email.
> To test this I set the Modify SLA to 15 minutes instead of 2 days to be sure
> it will work and it doesn't. Am I being stupid here? Is there a better way?
>
> Thanks
> Norm
Thanks for your reply:
When an item is created, modified or aged I have created a workflow with the
following conditions that trigger emails with specific content
Condition 1
IF Modified is less than Tasks:Create Min
Action
Send email (this works)
Create Min = Created+0.0001
Condition 2
Else if Modify SLA is less than Today
Action
Send email (this does not work ???)
Modify SLA = Modified+0.026
Condition 3
Else if Modified between Today and 6/11/2011
Action
Send email (this works)
I know I am not a wizard with this two of the triggers work and one does not.
Thanks
"Cornelius J. van Dyk [MVP]" wrote:
> My question would be this... what triggers the review of your Events
> i.e. in #1 the action of creating a new Event causes the workflow to
> trigger. In #2 the action of modifying an event causes the workflow to
> trigger, but in #3, you're depending on nothing to trigger the
> comparison of time that would trigger the workflow i.e. you're depending
> on *inaction* to trigger the process. Inaction cannot trigger a process
> so do you have some kind of service running that does the comparisons
> and kicks off the workflow?
>
> --
> Thanks
> C
> Blog: http://www.cjvandyk.com/blog
> RSS: http://feeds.feedburner.com/cjvandyk
> SPCAP - SharePoint Capacity Planning Tool
> http://www.cjvandyk.com/blog/aspx/SPCap.aspx
>
>
>
>
>
>
> "Norm ("I know nothing")" <NormIknownothing@discussions.microsoft.com>
> wrote in message
> news:D064C1C0-BEB9-4384-87FE-833B7FCDAC3A@microsoft.com:
>
> > I have set up a workflow in sharepoint with 3 branches 1.Event creation email
> > 2. Event modification email 3. Event not updated in 2 days email. It all
> > works except number 3.
> > To trigger the email, I created a calculated field in share point "Modify
> > SLA" with is the modified date plus 2 days. In the brank it is If Modify SLA
> > < Today send the email.
> > To test this I set the Modify SLA to 15 minutes instead of 2 days to be sure
> > it will work and it doesn't. Am I being stupid here? Is there a better way?
> >
> > Thanks
> > Norm
>
>
Have you debugged the thread to see what the values for "Modify SLA" and
"Today" is?
If the base types of the fields are not the same, it could be part of
the problem.
If you can't debug, you could always just write the values to a TXT file
to review after the action triggers.
"Norm ("I know nothing")" <NormIknownothing@discussions.microsoft.com>
wrote in message
news:725692E9-F92D-4C21-8697-8DFCF6D3EF2C@microsoft.com:
> Thanks for your reply:
> When an item is created, modified or aged I have created a workflow with the
> following conditions that trigger emails with specific content
>
> Condition 1
> IF Modified is less than Tasks:Create Min
> Action
> Send email (this works)
>
> Create Min = Created+0.0001
>
> Condition 2
> Else if Modify SLA is less than Today
> Action
> Send email (this does not work ???)
>
> Modify SLA = Modified+0.026
>
> Condition 3
> Else if Modified between Today and 6/11/2011
> Action
> Send email (this works)
>
> I know I am not a wizard with this two of the triggers work and one does not.
>
> Thanks
>
> "Cornelius J. van Dyk [MVP]" wrote:
>
> > My question would be this... what triggers the review of your Events
> > i.e. in #1 the action of creating a new Event causes the workflow to
> > trigger. In #2 the action of modifying an event causes the workflow to
> > trigger, but in #3, you're depending on nothing to trigger the
> > comparison of time that would trigger the workflow i.e. you're depending
> > on *inaction* to trigger the process. Inaction cannot trigger a process
> > so do you have some kind of service running that does the comparisons
> > and kicks off the workflow?
> >
> > --
> > Thanks
> > C
> > Blog: http://www.cjvandyk.com/blog
> > RSS: http://feeds.feedburner.com/cjvandyk
> > SPCAP - SharePoint Capacity Planning Tool
> > http://www.cjvandyk.com/blog/aspx/SPCap.aspx
> >
> >
> >
> >
> >
> >
> > "Norm ("I know nothing")" <NormIknownothing@discussions.microsoft.com>
> > wrote in message
> > news:D064C1C0-BEB9-4384-87FE-833B7FCDAC3A@microsoft.com:
> >
> > > I have set up a workflow in sharepoint with 3 branches 1.Event creation email
> > > 2. Event modification email 3. Event not updated in 2 days email. It all
> > > works except number 3.
> > > To trigger the email, I created a calculated field in share point "Modify
> > > SLA" with is the modified date plus 2 days. In the brank it is If Modify SLA
> > > < Today send the email.
> > > To test this I set the Modify SLA to 15 minutes instead of 2 days to be sure
> > > it will work and it doesn't. Am I being stupid here? Is there a better way?
> > >
> > > Thanks
> > > Norm
> >
> >