-
Getting a ‘syntax error’ error message when attempting to use this formula in Salesforce?
I am getting a 'syntax error' error message when attempting to use this formula as part of a workflow rule criteria. I have double-checked the field names are all correct. Can you tell me where I might going wrong?
AND (
NOT(ISPICKVAL(Payment_Detail__c, "Card")),
Days_Send__c = false,
ISPICKVAL(StageName, "Closed Won"),
NOT(Sector__c, "Customer 2"),
NOT(Product__c, "Customer 2"),
Account.Locale = "UK",
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"),
NOT(Prime_Account__c != "TotalCo")
)-
This discussion was modified 5 years, 7 months ago by
Deepak.
-
This discussion was modified 5 years, 7 months ago by
Forcetalks.
-
This discussion was modified 5 years, 7 months ago by Forcetalks.
-
This discussion was modified 5 years, 7 months ago by
-
1 Reply
-
Hi Deepak,
Looks like you're just missing some closing parenthesis on your second to last line
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"),
should be
NOT((OR(RecordType.Name != "Customer",RecordType.Name != "Customer 2"))),
to be syntactically correct.
Log In to reply.
Popular Salesforce Blogs
Guide to Install an App from AppExchange
Thank you for your interest in knowing how to install apps from AppExchange for Salesforce. Use my blog as a guide, it will help you…
Building Powerful B2B Customer Portal: The Shortcut
B2B transactions are often made with long-term clients, which are obtained by cultivating customer service and loyalty. To anticipate and satisfy clients’ needs, you will…
Role of Salesforce Implementation Partners in Data Migration
In today’s fast-paced business world, Salesforce stands out as a key player in customer relationship management and sales automation. Utilizing Salesforce Implementation Services can significantly…
Popular Salesforce Videos
Picklist fields in Salesforce Flow
In this video, we will talk about how to create picklist fields in Salesforce Screen flow. Below is the timestamp for your reference. Input Elements…
How to Nurture Leads in Salesforce Account Engagement? | Forms
Discover how Salesforce Account Engagement (also known as Pardot) helps you create and embed personalized forms, enhancing the lead nurturing experience. To show its capabilities,…
10 Example Future Method with Test Class | Asynchronous Apex | Salesforce Development Training Video
Salesforce uses a queue-based framework to handle asynchronous processes from such sources as future methods and batch Apex. This queue is used to balance request workload across…
