Best practice to run a workflow on the same records, only once per day.
Example Pipeline maintenance - Alert with email to users for any of their opportunities when Estimated close date is past due to update.
possible solution ? or is this a feature request?
other than creating two workflows
one that updates a hidden file custom field “opp last checked date” when it runs checks if last run date greater than now -1 day and updates it self daily
then a second workflow that checks if Close date is past due and last checked date is greater then now - 1 hour