You need to sign in to do that
Don't have an account?
Laura Brewer
Formula / Workflow Help!
Need to create a Workflow that sends an email notifying user when a 'Billing Type' picklist value changes FROM "Credit Card" TO any other picklist value. Intent is to notify Accounting to stop the credit card billing. Any ideas???
Hello Laura,
Please try with below formula.
Thanks and Cheers,
Jigar
All Answers
Hello,
Please review below snapshot.
You can create workflow rule for your object, with below critreia given in snapshot. as well as you can append email alert with email template in workflow action for send notification.
Thanks and Cheers,
Jigar
I do not want the Email Alert to trigger upon creation. I only want it to trigger if the Billing Type was selected as 'Credit Card' and subsequently changed to something else. If the user chooses another value on creation of the record I do not want the Email Alert to send. Will this Workflow Rule work for that?
This should work:
AND (ISCHANGED(Industry) ,
IF (TEXT(PRIORVALUE( Industry )) =='Banking', True, false ))
Note: Just change your field name to Billing type (api name) and value ( Credit Card) in above formula.
Screenshot:
Thanks,
Pratik
P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.
Hello Laura,
Please try with below formula.
Thanks and Cheers,
Jigar
Try this:
AND (ISCHANGED(
Billing_schedule__C
) ,
IF ( CONTAINS ( (TEXT(PRIORVALUE(
Billing_schedule__C
))), '
Credit Card
' ), True, false ))
Thanks,
Pratik
P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.