Workflow email trigger by date in SharePoint Server Design and Customization  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
Norm ("I know nothing") 6/26/2007 6:40 PM PST
  Question
  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
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Cornelius J. van Dyk [MVP] 6/27/2007 6:30 AM PST
  Answer
  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

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Norm ("I know nothing") 6/27/2007 1:46 PM PST
   
  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
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Cornelius J. van Dyk [MVP] 7/2/2007 4:47 AM PST
   
  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.

--
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: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
> >
> >

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies