Workflow triggering other Workflow recursively
Hello all,
We are trying to make a workflow to be launched on a weekly basis.
To do that we have 2 workflows :
1st Worflow :
Record Type : Opportunity
Trigger Event : When modified record saved
Workflow rule condition : Checkbox1 = "Y" (Checkbox1 is not the real name, it's just for the example)
(By default this checkbox is checked, so whenever we modify an opportunity the workflow1 is triggered)
Actions :
- Wait : Until when : Today() + (5 - (1.0 * IfNull( Mid(1.0 * JulianDay(Today())/7,8,2),0)/(7*2))) (This wait, "waits" until the next Saturday) (it's fine this is not our issue here)
- Field Update : We uncheck the Checkbox1
So far this field update, trigger an other workflow, the 2nd Workflow