function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Cory BeadleCory Beadle 

Workflow rule, one field dependent on 4 others

Thanks for the help everyone,
I am looking to have the Field "Type" automaticly update. 

Record Type must equal="AutoHook" for this workflow rule to trigger

Field "Type" = "Customer"  IF Field A or B = "Active"
Field "Type" = "Campaign" IF Field C or D = "Active" AND  Field A & B = anything but "Active"

**I would like the rule to reevaulate when Field A, B, C, or D is changed.
Balaji Chowdary GarapatiBalaji Chowdary Garapati

@Cory Beadle:

You need two work flow rules to accomplish the above requirement:

First Workflow rule condition would be:
(Ischanged(A) || Ischanged(B))&&(A==''Active' || B=='Active' ), and you can have a field update that says type='customer'

second workflow rule condition would be:
(Ischanged(C) || Ischanged(D))&&(A!=''Active' &&  B!='Active' ), and you can have a field update that says type="Campaign"



Hope this helps:

Thanks,
balaji
Cory BeadleCory Beadle
Thanks for the help, but I am running into an error. I took a screen shot below for you to view.

(Ischanged(Web2Show_Status__c)||Ischanged(Lead2Show_Status__c))&&(Web2Show_Status__c==''Active')||Lead2Show_Status__c)=='Active')

User-added image