Field Validation - Restricting length of data entered in the fields
Hi, I have a need to restrict the combined length of First and Last name fields in Contact to less than 26 characters for a Contact type 'Referral'.
The following validation rule triggers for all types of Contacts and not just Referral Contacts.
([<ContactType>]='Referral') AND ( ((Len([<ContactFirstName>])) + (Len([<ContactLastName>]))) < 25).
How can I make this to trigger only for the specific Contact type ?.
As an alternative, I tried the following but, got the same result as above.
<= IIf (FieldValue('<ContactType>') ='Referral', (Len([<ContactFirstName>]) + Len([<ContactLastName>]))<26, [<ContactFirstName>])
Any ideas on how to make this work for the specific contact type ?
The following validation rule triggers for all types of Contacts and not just Referral Contacts.
([<ContactType>]='Referral') AND ( ((Len([<ContactFirstName>])) + (Len([<ContactLastName>]))) < 25).
How can I make this to trigger only for the specific Contact type ?.
As an alternative, I tried the following but, got the same result as above.
<= IIf (FieldValue('<ContactType>') ='Referral', (Len([<ContactFirstName>]) + Len([<ContactLastName>]))<26, [<ContactFirstName>])
Any ideas on how to make this work for the specific contact type ?
0