You need to sign in to do that
Don't have an account?
KimberlyJ
Need help using Record Type in a formula
Would like to create a validation rule using record types. Keep getting syntax errors. Just want to have to select a picklist value if dollars are in the currency field.
Thanks.
RecordType.Name = "Networks Services"
Services__c <>0,
ISBLANK( Services_Product_Involved__c )
Thanks.
RecordType.Name = "Networks Services"
Services__c <>0,
ISBLANK( Services_Product_Involved__c )
We did NOT get any syntax errors but it did not work.
Thanks.
RecordType.Name = "Networks Services",
RecordType.Name = "Second Name",
OR(
Services_c<>0,
ISBLANK(Services_Product_Involved__c)))
AND (RecordType.Name = "Networks Services",
Services__c <>0,
ISBLANK( Services_Product_Involved__c ))
So here in your Validation rule, is the Services__c a number field? If it is, then you can compare it with 0. If it is not, then you can compare it with "null".
If you want to check multiple record types, you can try this:
AND(
OR(
RecordType.Name = "Networks Services",
RecordType.Name = "Second Name"),
OR(
Services_c<>0,
ISBLANK(Services_Product_Involved__c)))
)