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