Skip to main content
We need to require the field "Accounting Software" at the Opp level in SFDC prior to Opp creation. If not populated the Opp should not be created. We also want to ensure if that value ="Other", that they must enter a value in a text box to tell us what Accounting Software they are using.

 

How can I achieve this?
3 answers
  1. Sep 14, 2015, 9:31 PM
    Hi Chris,

     

    create 2 separate validation rules on opportunity object

     

    one for making sure the Accounting System is populated when a new opportunity is created and the second for a text box to be completed when the value in the Accounting system is Other

     

    1. validation rule

    ISBLANK(TEXT(Account.Accounting_System__c))

    Please use the insert field button to select the field api name by navigating to opportunity name - account - accounting system

     

    2. validation rule

    AND(

    Formula_Field_on_Opportunity__c = "Other",

    ISBLANK(Text_Field__c)

    )

    or alternatively

    AND(

    TEXT(Account.Accounting_System__c) = "Other",

    ISBLANK(Text_Field__c)

    )