Skip to main content
Topics#Formulaspooja biswas 的问题
pooja biswas 提问于 #Formulas
2017年1月20日 11:36

formula field trigger workflow

I have a Boolean formula field which is turn to true while records created date more than 3 days.

f this formula field turn to true then a workflow will trigger to change a lookup field (User) value, this workflow rule Evaluation Criteria I set as (created, and any time it's edited to subsequently meet criteria)

But when the formula field turn to true but lookup value still remains the same (it doesnt change)

Is this possible in salesforce?

Pooja

 
4 个回答
  1. Amit Singh (PantherSchools)
    2017年1月20日 11:47
    Hi Pooja,

    In Salesforce, when formula fields turn to true(OR changes) then it will not update the record in other words no DML is being performed on the record. That is why Lookup field remains same.

     

    The workaround to this problem is, you can write an Apex Batch which will take those records as input which has created date more than 3 days and then checks if formula field is true then update Lookup field otherwise, do not change.

     

    You can schedule your batch to execute at every 5 minutes or every day at night.

     

    Let me know if this makes sense.

     

    Thanks,

    Amit Singh.

撰写回答...
0/9000