I’m trying to figure out if process builder can update a field to the current date/time when the criteria is meet.
I want to track when an opportunity stage is selected. I know the tracking in down in the stage history however I need to have it on the detailed page.
I’ve tried $GlobalConstant.now, $GlobalConstant.now()… not sure if this is able.
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
I am not sure if there is a variable that would allow you to do this directly in the Process Builder. There are two workarounds that i am aware of:
- Create a formula field on the Process object set equal to Now() and use this to set the value.
- Create a record update or insert Quick Action on the Target Object and use the pre-defined values to set your desired field to Now(). This is my preferred option as you can use the pre-defined values in the quick action manage all of your field updates while using the familiar formula builder UI.
- Set the Target field equal to the Last Modified Date of the Source object. This will get you within a few seconds of Now() since the Process is triggered after the insert/update.
As mentioned before this is not available at this time. It was mentioned to use Visual Work Flow which is a viable work around.
That said I came up with my own solution: Create a formula field which is the formula of “now.” Then in Process Builder just use the “Now” field to set the date/time.
There is an idea for this here (unfortunately!).