• Linda McIntosh
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Global Project Manager
  • Green Belting Industries

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
What would be the best way to send an email alert to the CEO if three cases with the same lot # (a text field) are created in a 45 day period?  This is a moving target so, for instance, there could be 5 cases created but if 3 cases aren't created in the 45 day period, it should not fire.

Any suggestions?
What would be the best way to send an email alert to the CEO if three cases with the same lot # (a text field) are created in a 45 day period?  This is a moving target so, for instance, there could be 5 cases created but if 3 cases aren't created in the 45 day period, it should not fire.

Any suggestions?