Why won’t Process Builder let me wait less than one hour?

Ok.  I have a Salesforce Process Builder flow I created that sets a few field values, sends out some notifications and creates a Task after I assign a newly closed Opportunity to a member of my Project Management team.  I found that there were times I would change my mind right after making an assignment so I decided to have Process Builder wait for 5 minutes after my assignment before it went and did its thing.

Time Lapse

I can select hours or days but not minutes.  No problem.  Let’s see, 5 minutes is 5/60 of an hour or .083 minutes.  Away we go.

Time Lapse2

It turns out you can only select a whole number of days or hours in Process Builder.  So how can I tell it to wait for only five minutes?

Little-boy-getting-idea-with-lightbulb-over-head-600x576

But, 5 minutes from now is 1 hour from 55 minutes ago!  Since I can tell Process Builder to wait for 1 hour after any time field value, all I need to do is to create a custom formula field that is always 55 minutes ago.

My new field needs to be set to the current time, NOW(), less 55 minutes.  I need to specify my minutes as a fraction of a day so I’ll multiply 55 minutes times 1 day divided by 24 hours in a day divided by 60 minutes in an hour.

Formula_1

My new field will always be equal to 55 minutes before the current time when it gets evaluated so I can now tell Process Builder to wait for 1 hour after 55 minutes ago.

Time Lapse4.PNG

You can set this up for any time period you want.  Just change the number of minutes in the formula field from 55 to 60 minus however many minutes you want to wait.

4 thoughts on “Why won’t Process Builder let me wait less than one hour?

  1. Great idea. I’ve been able to do 0 Hours after Date_Field__c as well and that’ll just fire it a few seconds after, which is a great way to get around governor limits with triggers that need to run before your process.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s