Validation Rules on fields
Hi,
We're trying to setup some validation rules on fields in the Contacts and Accounts modules in ZOHO CRM. We have very stringent data requirements - e.gs:
- Phone Number - must be 6-10 characters, numerical only, no spaces or brackets, must start with 0 or 1
- Mobile Number - must be 10 characters - numerical only - no spaces or brackets, must start with 0
- Fax Number - same as phone number
- Suburb - Must be all uppercase
- Email - No uppercase letters
- ABN - must have 11 numeric characters
- ACN - must have 9 numeric characters
I've tried doing some of these with criteria, but I can't use criteria to dissallow spaces (it just says enter a valid phone), and that hasn't even excluded brackets either.
I know I can do this with functions, and I have the functions developed. The problem is I only get three functions to work with.
Is there a way to add extra functions, or can I perform these validation checks any other way?
Thanks
Luke