Apex Code Development You need to sign in to do that
Don't have an account?
azhar khasim Need help for my validation rule for the below one!!
I had a validation rule for which i was using to restrict as
If LOI Approval Status picklist value = Approved then only update the IsRenewed Chechbox = True.
*******************
If LOI Approved Status picklist value = (Rejected or Submitted) we don't want to make the IsRenewed checkbox to true.
*******************
Validation Rule:
ISPICKVAL(LOI_Approval_Status__c, Approved)
Please give me a solution for this
Thanks and Regards,
Azar Khasim.
If LOI Approval Status picklist value = Approved then only update the IsRenewed Chechbox = True.
*******************
If LOI Approved Status picklist value = (Rejected or Submitted) we don't want to make the IsRenewed checkbox to true.
*******************
Validation Rule:
ISPICKVAL(LOI_Approval_Status__c, Approved)
Please give me a solution for this
Thanks and Regards,
Azar Khasim.
I fixed the issue. its worked.
Actually i remorved the IF Function in it.
Like below
AND(ISPICKVAL(LOI_Approval_Status__c,'Submitted'), IsRenewed__c = TRUE)
||
AND(ISPICKVAL(LOI_Approval_Status__c , 'Rejected'), IsRenewed__c = TRUE)
But thanks for Skeleton form of validation rule.
I made tests and found it
Thank you for your help.
Thanks and Regards,
Azar Khasim.
All Answers
I hope you are doing well .....!!
Please use the below code:
IF( AND( ISPICKVAL( Active__c , 'No'), Match_Billing_Address__c = false ) ,true , false)
Here Active__c is picklist field and 'No' is picklist value.
Match_Billing_Address__c is check that we want it enable if Active__c is No
You can edit according to your requirement.
Hope this helps you.
Let me know you review or if you have ant query.
If this helps kindly mark it as solved so that it may help others in the future.
Thanks & Regards,
Foram Rana
Thanks for the response.
But it is not working for my requirement.
LOI Approval Status is Picklist Filed
IsRenewed is Chechbox Filed.
IF( AND( ISPICKVAL( LOI_Approval_Status__c, 'Approved'), IsRenewed__c= true ) ,true , false)
********************************************
In this requirement
only when LOI Approval Status = Approved then only we can update IsRenewed = True.
This is Working.
***********************************************
But this is not working for the above validation rule.
If LOI Approval Status = Submitted or Rejected then restrict the access to update IsRenewed = True.
**********************************************
Please provide a solution for thisss...
Thanks and Regards,
Azar Khasim.
I fixed the issue. its worked.
Actually i remorved the IF Function in it.
Like below
AND(ISPICKVAL(LOI_Approval_Status__c,'Submitted'), IsRenewed__c = TRUE)
||
AND(ISPICKVAL(LOI_Approval_Status__c , 'Rejected'), IsRenewed__c = TRUE)
But thanks for Skeleton form of validation rule.
I made tests and found it
Thank you for your help.
Thanks and Regards,
Azar Khasim.