Skip to main content
Topics#Data ManagementRodger Bannister의 질문
Rodger Bannister (Bruno Inc) 님이 #Data Management에 질문했습니다
2017년 11월 21일 오후 12:29

I need a validation rule that will make specified check boxes "required" if a date field on the same record is populated?

The goal is to trigger a notification if the specified date field is populated on a record then any of a list of checkboxes which are "false" must be updated to "true" in order to save the record. Here is the formula I came up with but it does not work - it triggers even if the date field is empty. Any help or suggestions would be greatly appreciated.

 

AND(OR( Move_In_Date__c  <> NULL,

 

Deposit__c  = FALSE,

 

Rental_Agreement_w_Addendums__c  = FALSE,

 

Property_Inspections__c = FALSE,

 

Unit_Inspection__c = FALSE,

 

Rental_Application__c = FALSE,

 

Move_In_Questionnaire__c = FALSE,

 

Move_In_Checklist__c = FALSE,

 

Thank_You_Note__c = FALSE))

 

Thanks, Roger
답변 6개
  1. Sunil Sarilla (M&G Investments)
    2017년 11월 21일 오후 12:46
    Hi Roger, I got that part i.e. not automating but when do you want the validation rule to be triggered?

     

    assuming you want the validation rule to be trigerred if atleast one of the checkboxes is unchecked then the formula will be as below

    AND(
    NOT(ISBLANK(Move_In_Date__c)),
    OR(
      Deposit__c  = FALSE,
      Rental_Agreement_w_Addendums__c  = FALSE,
      Property_Inspections__c = FALSE,
      Unit_Inspection__c = FALSE,
      Rental_Application__c = FALSE,
      Move_In_Questionnaire__c = FALSE,
      Move_In_Checklist__c = FALSE,
      Thank_You_Note__c = FALSE
      )
    )
답변을 작성하세요...
0/9000