CRM On Demand - Administration (MOSC)

MOSC Banner

Conditional Validation using IIF?

edited Aug 21, 2013 5:16AM in CRM On Demand - Administration (MOSC) 4 commentsAnswered
Hi Guys,

I need to write a validation script that has some common fields and some conditional. Can I use the IIF function to specify the validation formula?

e.g.

Common parts

Conditional

Field 1 IS NOT NULL AND Field 2 IS NOT NULL AND Field 3 IS NOT NULL AND ( IIF(COUNTRY='USA', (Field 4 IS NOT NULL AND Field 5 IS NOT NULL), (Field 6 IS NOT NULL AND Field 7 IS NOT NULL)))

I probably can do a separate script  like (USA AND 1 AND 2 AND 3 AND 4 AND 5) OR (<>USA AND 1 AND 2 AND 3 AND 6 AND 7)    but it may exceed 1024 characters also it would require duplication of all those common fields.

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