Melbourne
Data Validation - it's easy!
It has been now 4 weeks since the official release of Winter '07. Many of our customers took advantage of the new features to help them address a variety of their business challenges.
However you don't have to undertake major configuration changes to realise immediate benefits. One of the very powerful additions is the Data Validation option.
By implementing the simple validation rule on contact, opportunity or case records you can dramatically increase data quality and improve user adoption.
Here is a sample you can use to verify that the user enters only a valid name in a state field. Go to Setup | App Setup | Customize | Contacts | Validation Rules, create a new rule and enter below text into the "Error Condition Formula" field.
AND(
MailingState <> "ACT",
MailingState <> "NSW",
MailingState <> "NT",
MailingState <> "QLD",
MailingState <> "SA",
MailingState <> "TAS",
MailingState <> "VIC",
MailingState <> "WA"
)
For more information on Data Validation please click here
Click on the image below to see a screenshot of configuration page
Tomasz Oczapowski
Recent Comments
Comments Feed