Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vicky PanVicky Pan 

Workflow rule for field changing to a specific value

I currently have a workflow that triggers if a field (picklist) is updated. The formula is 
AND( 
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))), 
AVTRRT__Terminated__c = false )

I'm looking to create a new workflow that triggers a different email alert when the field is changed to the value Subscription.  So I'd like to update the existing formula above to not trigger if the field's new value is Subscription and create a new workflow that triggers only when the field is updated and the new value is Subscription, just not sure what functions will be best.  

Help appreciated! =)
Best Answer chosen by Vicky Pan
Mahesh DMahesh D
Hi Vicky,

You can try below one:

AND( 
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISPICKVAL(Hire_Type__c, 'Subscription')),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))), 
AVTRRT__Terminated__c = false )

For the second one:


AND( 
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
ISPICKVAL(Hire_Type__c, 'Subscription'),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))), 
AVTRRT__Terminated__c = false )

Please let me know if it helps.

Regards,
Mahesh

All Answers

Mahesh DMahesh D
Hi Vicky,

You can try below one:

AND( 
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
NOT(ISPICKVAL(Hire_Type__c, 'Subscription')),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))), 
AVTRRT__Terminated__c = false )

For the second one:


AND( 
NOT(ISNEW()),
ISCHANGED(Hire_Type__c),
ISPICKVAL(Hire_Type__c, 'Subscription'),
NOT(ISBLANK(PRIORVALUE(Hire_Type__c))), 
AVTRRT__Terminated__c = false )

Please let me know if it helps.

Regards,
Mahesh
This was selected as the best answer
sumit singh 37sumit singh 37
you cannot use is change in the workflow
for that use the third criteria 
created, and any time it's edited to subsequently meet criteria  for the  (Hire_Type__c) field