Skip to main content

After scouring the questions in this group for hours, to no avail, I am hoping that someone can assist in helping me with a VR

 

When I originally created this rule - it was based on one and/or of the fields having to be required, and now it has changed where both fields will be required - so not quite sure why this is so difficult to adjust.... 

  • When Service Request Stage = Order, the 'Network Platform' AND 'Network Routing' field are both required.
  • Applies to multiple record types (included below)

 

Error Condition Formula:

 

AND

 

(ISPICKVAL(Service_Request_Stage__c, "Order"),

 

OR (RecordType.DeveloperName = "Voice_Trunk_Fiber_AE_Read_Only",

 

RecordType.DeveloperName = "Voice_Trunk_Fiber",

 

RecordType.DeveloperName = "Voice_Trunk_DOCSIS_AE_Read_Only"),

 

AND(ISBLANK(TEXT(Network_Routing__c))),

 

OR (ISBLANK(TEXT(Network_Platform__c))))
10 respuestas
  1. 29 oct 2020, 0:10
    Hi,

     

    You may try with below formula:

     

    AND(

    ISPICKVAL(Service_Request_Stage__c, "Order"),

     

    OR (

    RecordType.DeveloperName = "Voice_Trunk_Fiber_AE_Read_Only",

     

    RecordType.DeveloperName = "Voice_Trunk_Fiber",

     

    RecordType.DeveloperName = "Voice_Trunk_DOCSIS_AE_Read_Only"

    ),

     

    OR(

    ISBLANK(TEXT(Network_Routing__c)),

     

    ISBLANK(TEXT(Network_Platform__c))

    )

    )

0/9000