I have two custom objects A & B, expiration date is a field on Obj A, formula field on B, we need a time dependant workflow rule to change the status field on B to "Not Completed" when the expiration date is done and the status field is "Open", Can you please help with the rule criteria.
Advance Thanks.
2 Antworten
create a workflow rule on object b
evaluation criteria:
created, and any time it’s edited to subsequently meet criteria
rule criteria: status = open
Under Time-Dependent Workflow actions
click on Add Time Trigger
0 hours after "Select the Date Formula Field of Object B"
Add Workflow action
New Field update
select your status field to update
save and activate your workflow rule.
Please note the workflow rule will not work in some cases
for e.g. lets say you have created a record in Object A but did not complete the date field and you have created the related B record, the formula field will be empty because the date field is empty on object A, now lets say your users go and update the Date field on Object A, the workflow will only fire if record is edited on object B.
and for the above mentioned scenario a better solution is a Trigger rather than a work flow.