Skip to main content
Topics#Data ManagementDomanda di Corey Price
Corey Price (Company Wrench Ltd.) ha fatto una domanda in #Data Management
10 mag 2019, 19:21

Blank Picklist Validation Rule

I am trying to make a validation rule that includes a picklist field being not selected. The problem I am running into, is the validation rule picking up on that part of the formula. I cannot seem to figure out a way to describe a blank picklist field in my formula. So far I have tried:

 

Blank Picklist Validation Rule

 

User-added image

 

Neither of these formulas bring up the error message when I go to make a new record:

 

User-added image

 

Does anyone have thoughts on how to write a formula that that picks up on the Vendor ' C W Transport' and the CW Transport Driver being blank?

 

Thanks
7 risposte
  1. Adam Johnson (DoubleTrack)
    10 mag 2019, 20:18
    You have

     

    "Vendor_Object__c = "C W TRANSPORT" "

     

    I'm suggesting

     

    Vendor_Object__c.Name = "C W TRANSPORT",

     

    Vendor_Object__c is looking for the ID of the record, not the name, which is why the rule isn't firing.  

     

    You'll need to use the field picker to get the exact API name for Vendor_Object__c.Name
Scrivi una risposta...
0/9000