CRM On Demand - Administration (MOSC)

MOSC Banner

Help with Field Validation syntax

edited Sep 27, 2013 12:11PM in CRM On Demand - Administration (MOSC) 1 commentAnswered
Hi,


I'm trying to write a field validation rule that won't allow the email field on the contact form to be left NULL once a value was entered, but exclude a specific contact type from this rule.

I have this syntax:

(PRE('<ContactEmail>') IS NULL AND [<ContactType>]<> LookupValue("CONTACT_TYPE", "Contact"))

the 'PRE' portion of the validation works, however its not taking into account the contact type value and prompts me even when the contact type is Contact.

Any help would be appreciated.

Jo-Ann

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center