Skip to main content
Topics#Data ManagementRoger Bannister의 질문
Roger Bannister 님이 #Data Management에 질문했습니다
2015년 6월 9일 오후 2:04

Validation rules run in Sandbox but cannot save after fix, why?

I have created a validation rule for Case "Status" field that requires another field to be populated when Status is changed to "Closed". The rule works and I get the error message but when I populate the secondary field to meet the rule requirements and try to save it still won't let me I get the rule error message again. What have I done wrong? I'm doing this in a Dev Sandbox if that is relevant.
답변 9개
  1. Chidambar Reddy (FormulaQ Solutions Private Limited)
    2015년 6월 9일 오후 2:12
    Hi Roger,

     

    If you want a field to be mandatory on a perticular Status, use the following validation rule

    AND(
         ISPICKVAL(Status,'Closed'),
         ISBLANK(OtherFieldName__c)
    )

    When the other field is a picklist, use the below

    AND(
         ISPICKVAL(Status,'Closed'),
         ISBLANK(TEXT(PicklistName__c))
    )
답변을 작성하세요...
0/9000