You need to sign in to do that
Don't have an account?
Diego Moreno
Validation rule formula question
Hello,
i am trying to create a formula that doesn't allow usesr to edit certain fields once a record is save with a checkbox clicked, so i need the formulla to depend on whether or not the check box is clicked.
this is what i've got so far:
AND(PRIORVALUE( Is_approved__c ), TRUE,
ISCHANGED( Is_approved__c )) || ISCHANGED( Gross_Pay__c ) || ISCHANGED( End_Date_del__c ) || ISCHANGED( Has_dental_vision_insurance__c ) || ISCHANGED( Has_Medical_Insurance__c ) || ISCHANGED( Start_Date__c ) || ISCHANGED( Name ) || ISCHANGED( Net_Pay__c )
i am trying to create a formula that doesn't allow usesr to edit certain fields once a record is save with a checkbox clicked, so i need the formulla to depend on whether or not the check box is clicked.
this is what i've got so far:
AND(PRIORVALUE( Is_approved__c ), TRUE,
ISCHANGED( Is_approved__c )) || ISCHANGED( Gross_Pay__c ) || ISCHANGED( End_Date_del__c ) || ISCHANGED( Has_dental_vision_insurance__c ) || ISCHANGED( Has_Medical_Insurance__c ) || ISCHANGED( Start_Date__c ) || ISCHANGED( Name ) || ISCHANGED( Net_Pay__c )
If I read your requirements correct (These fields cannot be changed if Is_Approved__c is checked) then the formula should be :
ISCHANGED() formula only evaluates to true on update, not insert.
If the checkbox should be false to enforce this then it should read:
All Answers
If I read your requirements correct (These fields cannot be changed if Is_Approved__c is checked) then the formula should be :
ISCHANGED() formula only evaluates to true on update, not insert.
If the checkbox should be false to enforce this then it should read: