Skip to main content
Topics#Data ManagementQuestion de Brian Cotlove
Brian Cotlove a posé une question dans #Data Management
13 juil. 2017, 19:33

Validation rule with multiple fields

I have looked at many different multiple validation rule threads here in the Success community, but for some reason my code does not want to work.

 

I have a custom object where and am trying to create a validtion rule that, if both of the two fields are true:

  1. Website Setup Category = New Website
  2. Onboarding Stage = Launched

then the following fields need to have some value (not be blank), else an error:

  • Design Setup   (picklist)
  • Theme    (picklist)
  • Launch Date   (date)

Here are two versions of code I've tried, both of which aren't working.

 

Option 1
AND(
ISPICKVAL(  Onboarding_Stage__c  , 'Launched'),
ISPICKVAL(  Website_Setup_Category__c  , 'New Website'),
OR(
ISBLANK (TEXT ( Design_Setup__c),
ISBLANK (TEXT (Theme__c),
Launch_Date__c = null,
))

 

Option 2
AND(
ISPICKVAL(  Onboarding_Stage__c  , 'Launched'),
ISPICKVAL(  Website_Setup_Category__c  , 'New Website'),
OR(
ISPICKVAL( Design_Setup__c, ''),
ISPICKVAL( Theme__c), ''),
Launch_Date__c = null,
))

 

The error message I'm getting is:     Error: Syntax error. Found ')

 

All of the fields are on the same custom object.

 

Thanks in advance for your assistance!

 

 
8 réponses
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    13 juil. 2017, 19:53

    Lets try this = 

    AND(
        TEXT(Onboarding_Stage__c) = "Launched",
        Website_Setup_Category__c = "New Website",
        OR(
            ISBLANK(TEXT(Design_Setup__c)),
            ISBLANK(TEXT(Theme__c)),
            ISBLANK(Launch_Date__c)
        )
    )
Rédiger une réponse...
0/9000