CRM On Demand - Administration (MOSC)

MOSC Banner

Field validation on product name

edited Jul 3, 2013 3:29AM in CRM On Demand - Administration (MOSC) 8 commentsAnswered ✓
 Hi,
I'm trying to create a field validation that makes a picklist field required for specific products (in Opportunity Product Revenue).  The closest I've gotten is with the following: 
  
       ((FieldValue('<ProductName>')="Workshop") AND ([<plComponent_ITAG>] IS NOT NULL)) OR (FieldValue('<ProductName>')<>"Workshop")

I have this validation on both the Component field (picklist) and the Product ID field (since I can't do validation on the product field).  I'm not sure if I'm evaluating the product name properly because when I use just the first statement (before the OR) it evaluates as False for everything and always requires Component to be filled in and when I add the second statement, it doesn't trigger at all.

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