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
Patrick James 13Patrick James 13 

Help Understanding AND/OR syntax

Hi,

I am just trying to get a handle on AND/OR syntax.  I have the following that does not get a syntax error, but I am not sure it is doing what I want it to.

What I want is for this to trigger if:

date_Sent_to_Customer is today
OR
if the RecordType is Quote Request and the Quote Amount is > 5000.

Does this do that?

AND
(  OR   (TODAY() =  Date_Sent_to_Customer__c ),
    RecordType.Name = "Quote Request",
    Quote_Amount__c > 5000,
 )
 
Best Answer chosen by Patrick James 13
Raj VakatiRaj Vakati
Try this 
  
OR(
 Date_Sent_to_Customer__c =TODAY(),
 AND(
     RecordType.Name = "Quote Request",
    Quote_Amount__c > 5000
	)
)

 

All Answers

Raj VakatiRaj Vakati
Try this 
  
OR(
 Date_Sent_to_Customer__c =TODAY(),
 AND(
     RecordType.Name = "Quote Request",
    Quote_Amount__c > 5000
	)
)

 
This was selected as the best answer
Patrick James 13Patrick James 13
Thanks Raj!  That works, and I now see how the logic works.