function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mitsvikmitsvik 

USING AND AND NOT LOGICAL

I have the following query and it sthrowing an error that i need an extra bracket.i think i have it all right , but not sure why an error

AND((RecordType.Name = ("Prospect"),OR(ISBLANK( FirstName),ISBLANK( PersonMailingCity),ISBLANK( PersonMailingStreet ),ISBLANK( PersonMailingPostalCode))&&(NOT($User.BypassVR__c) && ($RecordType.Name = "Member" || $RecordType.Name = "Prospect") && ISBLANK( FirstName))&&(NOT($User.BypassVR__c) && NOT( OR( ISBLANK(Phone ), REGEX( Phone ,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}")))))
Raj VakatiRaj Vakati
Try this
  
AND(
RecordType.Name = ("Prospect")
,OR(
ISBLANK( FirstName),ISBLANK( PersonMailingCity),ISBLANK( PersonMailingStreet ),ISBLANK( PersonMailingPostalCode)
)
&&
NOT(($User.BypassVR__c)
 && ($RecordType.Name = "Member" || $RecordType.Name = "Prospect")
 && ISBLANK( FirstName))
 &&(NOT($User.BypassVR__c) && NOT( OR( ISBLANK(Phone ), REGEX( Phone ,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}")))))