You need to sign in to do that
Don't have an account?
Pankaj Pandey 22
validation Rule if the Checkbox is checked then fields are required for Specific Record Type
Hi All,,
I am writing the Validation rule for specific record type on check of check box i want the mobile field to become madator. I have written below code and it is not working :-
IF( RecordType.DeveloperName = "Testing", AND(Text_Consent__c = True, ISBLANK(MobilePhone__c)), NULL)
If I just write below code it works fine :-
AND(Text_Consent__c = True, ISBLANK(MobilePhone__c))
Any idea what is going wrong when i am adding the record type.
Thanks,
Pankaj Pandey
I am writing the Validation rule for specific record type on check of check box i want the mobile field to become madator. I have written below code and it is not working :-
IF( RecordType.DeveloperName = "Testing", AND(Text_Consent__c = True, ISBLANK(MobilePhone__c)), NULL)
If I just write below code it works fine :-
AND(Text_Consent__c = True, ISBLANK(MobilePhone__c))
Any idea what is going wrong when i am adding the record type.
Thanks,
Pankaj Pandey
IF(RecordType.Name = 'Testing', AND(Text_Consent__c = True, ISBLANK(MobilePhone__c)), false)
Personally think it was due to the DevName VS name that you were using also might want to try single quotes and null can not be returned. The explaination for the if statement is below:
IF(logical_test, value_if_true, value_if_false)
Hope this helps!
AM
All Answers
IF(RecordType.Name = 'Testing', AND(Text_Consent__c = True, ISBLANK(MobilePhone__c)), false)
Personally think it was due to the DevName VS name that you were using also might want to try single quotes and null can not be returned. The explaination for the if statement is below:
IF(logical_test, value_if_true, value_if_false)
Hope this helps!
AM
Try to use this in your validation rule.Should work and replace 'testing' with a valid recordtype developername.
thanks for the quick reply. What if if have two check box and both are not checked then make some field madatory for same Record Type.
Thanks,
Pankaj Pandey
If this is what you are asking you might have to try a VF page and require the firld if it meets your criteria
there are two fields i.e., in time and out time and one checkbox absent.
if the checkbox absent is checked it should not allow us to enter intime and outime
can anyone give me validation rule for this?
Did you build the validation rule? I am looking for something similar.