Skip to main content
Topics#FormulasPregunta de Laura Dix-Bowler
Laura Dix-Bowler ha preguntado en #Formulas
21 jul 2017, 9:36

Validation rule that references product and opportunity fields

I'm trying to create a validation rule that requires a custom opportunity field to be populated (look up field) before being able to add a specific discount product to the opportunity. Is this possible? 

AND(

  ISBLANK(Ambassador_Referral__c),

  TEXT(Product2.ProductCode, 'REFDISCOUNT')

)

Error: Field Product2 does not exist. Check spelling.
5 respuestas
  1. Gulshan Raj (Publicis Sapient)
    21 jul 2017, 10:06
    Hi Laura,

    To get the references of both product and opportunity fields. Please move this validation rule to opportunity product and follow formula mentioned below:

    AND(
      ISBLANK(Opportunity.Ambassador_Referral__c),
      Product2.ProductCode='REFDISCOUNT'
    )

    Please let me know if you have any quesiton.

    Thanks & Regards

    Gulshan Raj

    LinkedIn (https://www.linkedin.com/in/gulshan-raj-a26b0640/)

    Twitter (https://twitter.com/gulshan_bittoo)

     
Escribir una respuesta...
0/9000