+ Start a Discussion
heatherwebsterheatherwebster 

Workflow Rule: Running Only Once a Day

I have a workflow set up to trigger when a Sales Profile updates an opportunity and I need to expand some criteria.
 
This is what I have currently.  Now, I need to factor in when a Sales Profile has already updated the opportunity for the day so that it doesn't trigger more than once a day.
Code:
OR(
  $User.ProfileId ="00e50000000vGpt",
  $User.ProfileId ="00e50000000vGcG",
  $User.ProfileId ="00e50000000vGpj",
  $User.ProfileId ="00e50000000vH76",
  $User.ProfileId ="00e50000000vHv5")

 I tried this, but run into the problem when it's Today and someone else (other than sales) updates the record, it won't trigger and I want it to. *Last Modified Date 1 is a custom field that displays the date field and not date/time.
Code:
AND( 
  OR(
  $User.ProfileId ="00e50000000vGpt",
  $User.ProfileId ="00e50000000vGcG",
  $User.ProfileId ="00e50000000vGpj",
  $User.ProfileId ="00e50000000vH76",
  $User.ProfileId ="00e50000000vHv5"), 
AND(
Last_Modified_Date_1__c <>TODAY(),
LastModifiedBy.Id <> $User.Id )
)
)
 
My other thought was creating a field update to tag if an opportunity already had the trigger pulled for the day and use that as the last modified criteria, but I think I would run into trouble resetting the field each day.

Any assistance or direction is appreciated!