You need to sign in to do that
Don't have an account?
Nitin Kapoor 15
Workflow field update in same transaction
I am trying to figure out whether we can set a date field to todays date if its NULL. When the user moves the status to ‘complete’ I’d like to give them the option to enter an XYZ date, and if they don’t then this field should be filled with today’s date. I have created a workflow rule that does most, but not all of this.
The workflow rule successfully pushes todays date if the field is null, however if the user pressed ‘edit’ and changes the Status as "Complete" along with adding an XYZ date all in the same ‘edit’ action, the date they enter is overwritten with “today”. I need to accept the entered value and not overwrite it. Is this possible using workflow or process builder. I know I can do it using the trigger but I want to avoid writing a trigger?
The workflow rule successfully pushes todays date if the field is null, however if the user pressed ‘edit’ and changes the Status as "Complete" along with adding an XYZ date all in the same ‘edit’ action, the date they enter is overwritten with “today”. I need to accept the entered value and not overwrite it. Is this possible using workflow or process builder. I know I can do it using the trigger but I want to avoid writing a trigger?
There is a small and easy alternative for this if you want the date to be default as TODAY.
You can just provide a default value of the field as TODAY().
P.S- This will not keep the date field as null.
Or, try changing the criteria of Workflow to:
Hope this helps!
Thank you,
Ajay Dubedi
I would suggest below solutions for this business case -
1. Create Workflow rule and set evalutation criteria as 'Created'
2. As default set today's date in field update action - as you already done
3. After that create validation rule and add the condition as status to ‘complete’ then only user can change the date.
I hope it will definitely help you.
Regards,
Kakasaheb