Skip to main content
I want to create an approval criteria formula that check to see whether certain fields are populated before allowing the record to flow through to the apporval work flow. I have a page validation script that I use later on in my process to ensure fields are populated. If the below script is true then it throws an error. However for the apporval criteria I want it to ensure all of the below fields have a value before executing the apporval workflow, how can i adapt this script to put into the entry criteria.....?

 

here is the page validation I want to modify for the apporval criteria;

 

AND (

 

ISPICKVAL(StageName, "2 - Capture (Pre Gate 1 - Go)"),

 

($RecordType.DeveloperName = "New_Contract_Opportunity_Naval"),

 

OR(

 

(Stage_2_Approved__c = FALSE),

 

ISPICKVAL(Division__c, ""),

 

ISPICKVAL(Thales_Division__c, ""),

 

ISPICKVAL(Strategic_Business_Line_SBL__c, ""),

 

ISPICKVAL(Business_Unit__c, ""),

 

ISBLANK( Account.Name),

 

ISPICKVAL(Customer_Program_Name__c, ""),

 

ISPICKVAL(Customer_Program_Phase__c, ""),

 

ISBLANK(Name),

 

ISPICKVAL(Country__c,""),

 

ISBLANK(End_User_b__c),

 

ISPICKVAL(Site__c , ""),

 

ISPICKVAL(Legal_Entity_Prime_Contractor__c,""),

 

ISPICKVAL(Country_of_Legal_Entity__c,""),

 

ISPICKVAL(Ex_group_Intra_group__c, ""),

 

ISPICKVAL(Domestic_Import_Export__c, ""),

 

ISPICKVAL(MIL_CIV__c, ""),

 

ISBLANK(RFP_Issue_Date__c),

 

ISBLANK(Proposal_Due_Date__c),

 

ISBLANK(CloseDate),

 

ISPICKVAL(Prospect_Type__c,""),

 

ISPICKVAL(Category__c,""),

 

ISBLANK(P1__c),

 

ISBLANK(P2__c),

 

ISBLANK(Amount),

 

ISPICKVAL(Currency__c,""),

 

ISBLANK(Exchange_Rate__c),

 

ISBLANK(Contract_Gross_Value_Contract_Currency__c),

 

ISPICKVAL(Bid_Category__c, ""),

 

ISPICKVAL(Capture_Lead__c, ""),

 

ISPICKVAL(Sales_Lead__c, ""),

 

ISPICKVAL(Sales_Manager_Country__c, ""),

 

ISPICKVAL(Sales_manager_Unit__c, "")

 

))
4 respuestas
  1. 7 ene 2011, 11:49 a.m.
    I do not think it is possible to integrate Validation Rules and Approval Processes, meaning you cannot add anything to a Validation Rule that would effect Approval Processes in any way.

     

    I don't even think that an Apex trigger can help here based on the processing rules. It would require someone with better knowledge of apex to answer but essentially you want something that fires the validation rule if the Approval Process is submitted.

     

    Good luck. Sorry I cannot be more help on this.