Skip to main content
Topics#FormulasPergunta de pooja biswas
pooja biswas perguntou em #Formulas
20 de jan. de 2017, 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 respostas
  1. Amit Singh (PantherSchools)
    20 de jan. de 2017, 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.

Escrever uma resposta...
0/9000