AND (
NOT(ISBLANK ( lookup__r.Name )))
||
Retroactively_Triggers_Workflow__c =true
The Retroactively Triggers Workflow checkbox field was updated for all existing contacts using the DataLoader.
My problem is that the value only gets updated if a new Contact record is created... and I want all records to be updated with that custom text value whenever the record is modified.
The field that gets update is a custom text field and I set the value of that custom text field with a formula.
CustomObject__r.CustomContact__r.FirstName
Can anyone tell me what I'm doing wrong?
10 件の回答
I think the formula should be:
AND(
NOT(ISBLANK(SAgent__r.Name)),
Retroactively_Triggers_Workflow__c = true
)
This equates to the workflow firing when the checkbox for retroactive triggers workflow is checked and there is avlue in the SAgent Name field.
With the way you set up the trigger, this will fire when the values are changed to meet these criteria. i.e. it will fire once when that box is checked to true. But if you want it to fire again you need to either uncheck and re-check it, or change the trigger to fire every time the workflow is edited.