Currently I have the following workflow, but it doesn't work the way I expect it to because if the user changes the value from Complete --> Planned --> Complete it would update the 'Actual Date Complete' twice. Any help would be appreciated!
답변 6개
Diana, you can do it like this:
1. Create a hidden checkbox on the object (Fire_once__c)2. Change the workflow rule criteria to include the following:
Fire_once__c = FALSE
So the criteria will look like this:
AND(
Fire_Once__c = FALSE,
OR(
...
....
....
)
)
The bolded part stays the same which is your existing criteria.
3. Add another field update to your rule to update this checkbox field to TRUE.
This way your workflow rule only fire once and never again.
