Skip to main content
Hi,

 

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 个回答
  1. 2014年10月21日 22:04
    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.