You need to sign in to do that
Don't have an account?
twrig15
Validation Rule to Restrict Creation of a record
Hi Everyone,
I have 3 validation rules that looks a qty of a field and the available qty on the account record and it restricts creation if the login in qty is > than the available qty.
The issue is that I have 3 separate validation rules that looks at the same Login Qty field is the and when they are all activated that conflict with each other. Can you assist in creating a single formula that acts for the 3?
Formula 1:
AND( Login_Qty__c > Account__r.Total_Of_User_Login_s_Available__c)
&&
NOT( No_Charge_Login__c = TRUE)
Formula 2:
AND(Login_Qty__c > Account__r.Total_Of_Systems_Login_s_Availab__c )
&&
NOT( No_Charge_Login__c = TRUE)
Formula 3:
AND(Login_Qty__c > Account__r.Total_Of_Login_s_Available__c)
&&
NOT( No_Charge_Login__c = TRUE)
Thanks!
I have 3 validation rules that looks a qty of a field and the available qty on the account record and it restricts creation if the login in qty is > than the available qty.
The issue is that I have 3 separate validation rules that looks at the same Login Qty field is the and when they are all activated that conflict with each other. Can you assist in creating a single formula that acts for the 3?
Formula 1:
AND( Login_Qty__c > Account__r.Total_Of_User_Login_s_Available__c)
&&
NOT( No_Charge_Login__c = TRUE)
Formula 2:
AND(Login_Qty__c > Account__r.Total_Of_Systems_Login_s_Availab__c )
&&
NOT( No_Charge_Login__c = TRUE)
Formula 3:
AND(Login_Qty__c > Account__r.Total_Of_Login_s_Available__c)
&&
NOT( No_Charge_Login__c = TRUE)
Thanks!
1. Below validation rule will fire if the Login_qty__c must be greater all the account 3 fields 2. Below validation rule will fire if the Login_qty__c is greater than any one of the account field
view sourceprint?
All Answers
1. Below validation rule will fire if the Login_qty__c must be greater all the account 3 fields 2. Below validation rule will fire if the Login_qty__c is greater than any one of the account field
view sourceprint?
AND( Login_Qty__c > Account__r.Total_Of_User_Login_s_Available__c,
Login_Qty__c >Account__r.Total_Of_Systems_Login_s_Availab__c,
Login_Qty__c >Account__r.Total_Of_Login_s_Available__c)
&& NOT( No_Charge_Login__c = TRUE)
The other code block just uses OR() instead of AND(). I would make a slight tweak though just for the appearance:
Login_Qty__c > Account__r.Total_Of_User_Login_s_Available__c &&
Login_Qty__c >Account__r.Total_Of_Systems_Login_s_Availab__c &&
Login_Qty__c >Account__r.Total_Of_Login_s_Available__c &&
!No_Charge_Login__c
@twig15, if you choose to go with this solution, please mark @S.Karanraj's answer as best, not mine.
Thanks,
Parker