Workflow is an automated process to implement the business logic, that evaluates the record at the time of creation or update. It is one of the most powerful tools of Salesforce.
Workflow becomes indispensable to organizations for maximizing efficiency in their business processes. It allows tracking of processes.
Time dependent workflow has the following actions:-
1) New Email Alert.
2) New Field Update.
3) New Outbound message.
4) Select existing actions.
The “existing actions” again have the following actions:
a) Email Alert.
b) Field Update.
c) Outbound message.
Values such as days and hours only are supported by Salesforce for Time dependent workflows. The minimum value for them is 1. What if we get a requirement in which we need to send a mail just after 10 minutes or 20 minutes of a record creation? Well, Time based workflows have 1 hour as the minimum duration to fire the workflow. In this case we need to by-pass this limitation. For this we need to use a particular technique. This requires us to write a custom formula field that calculates Date/Time value. Let us create a formula field as Trigger Time 20.
This formula field actually saves “Date/Time” value to your record which is 40 minutes in the past. If you save the record at 2:00 pm then the value in the “Trigger Time 20” will be 1:20 pm.
The formula for the Trigger Time 20 is:-
Trigger Time20 = (now () – 0.02764)
So now we need to create a time based workflow rule that fires 1 hour after Trigger Time 20. So 1 hour after a time which was 40 minutes ago, is 20 minutes from now.
This formula field will be accessible to all users but need not to be present in the layout.
Here is the chart which shows the values needed to be subtracted from now() function for each 5 minutes interval:-
Value in formula Minutes ago will fire in (minutes)
0.04145 60 0
0.03800 55 5
0.03455 50 10
0.03109 45 15
0.02764 40 20
0.02418 35 25
0.02073 30 30
0.01727 25 35
0.01382 20 40
0.01036 15 45
0.00691 10 50
0.00345 5 55
0.00069 1 59