Skip to main content
Chris 님이 #Sales And Marketing에 질문했습니다
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개
  1. 2015년 9월 14일 오후 9:31
    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)

    )