Skip to main content
Topics#Data ManagementPregunta de Lynn Molina
Lynn Molina (ProSoft Technology) preguntó en #Data Management
20 sept 2017, 22:50

My Workflow Rule is triggering upon ANY change of a specific pick list value.

My Workflow Rule is triggering upon ANY change of a specific pick list value. I need it to trigger only when the field (Type) is changed TO a specific value (Authorized Distributor). There are several options in the pick list values. I have the Evaluation Criteria set to "Evaluate the rule when a record is created, and every time it's edited". Can someone help to correct my Rule Criteria? Thank you! :-)

 

AND(

 

ISCHANGED(Type),

 

OR(

 

TEXT(PRIORVALUE(Type)) = "System Integrator",

 

TEXT(PRIORVALUE(Type)) = "Competitor",

 

TEXT(PRIORVALUE(Type)) = "Prospect",

 

TEXT(PRIORVALUE(Type)) = "Supplier",

 

TEXT(PRIORVALUE(Type)) = "OEM",

 

TEXT(PRIORVALUE(Type)) = "Media",

 

TEXT(PRIORVALUE(Type)) = "--NONE--",

 

(TEXT(Type)="Authorized Distributor")

 

)

 

)

 

 
6 respuestas
  1. Sunil Sarilla (M&G Investments)
    20 sept 2017, 23:36
    Apologies missed an comma

     

    please try the below

    AND(
    ISCHANGED(Type),
    OR(
    TEXT(PRIORVALUE(Type)) = "System Integrator",
    TEXT(PRIORVALUE(Type)) = "Competitor",
    TEXT(PRIORVALUE(Type)) = "Prospect",
    TEXT(PRIORVALUE(Type)) = "Supplier",
    TEXT(PRIORVALUE(Type)) = "OEM",
    TEXT(PRIORVALUE(Type)) = "Media",
    TEXT(PRIORVALUE(Type)) = "--NONE--"
    ),
    TEXT(Type)="Authorized Distributor"
    )
Escribir una respuesta...
0/9000