How to check a record is a new record or already created one

Question

I'm unable to figure out on how to add "NOT(ISNEW)" and "AND" to my validation rule which is OR( OR( Auditee__r.VanaHCM__User__c <> $User.Id , Auditee_2__r.VanaHCM__User__c <> $User.Id), ISCHANGED( Audit_Closure_Target_Date__c ) , ISCHANGED( RCA__c ) , ISCHANGED( Proposed_Correction_Corrective_Actions__c ) ) as I need to fire this rule only in a record already created but this rule of mine fires even before i create a record and save it.

Nemesis88 · Answer

This is the answer to my question which I figured at long last on my own. Thank u @Timothy

AND( NOT( ISNEW()), 
     ISCHANGED( Audit_Closure_Target_Date__c ) , 
     ISCHANGED( RCA__c ) , 
     ISCHANGED( Proposed_Correction_Corrective_Actions__c),
     OR( Auditee__r.VanaHCM__User__c <> $User.Id , 
         Auditee_2__r.VanaHCM__User__c <> $User.Id)
   )

Answered by Nemesis88 on December 7, 2021

Tim · Answer

You could try a few things: NOT(ISNEW()) Or: DATEVALUE(CreatedDate) <> Today() Or: CreatedDate <> NOW()

How to check a record is a new record or already created one

2 Answers

Add your own answers!

Ask a Question