-
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 4 years, 8 months ago by
Deepak.
-
This discussion was modified 4 years, 8 months ago by
Forcetalks.
-
This discussion was modified 4 years, 8 months ago by Forcetalks.
-
This discussion was modified 4 years, 8 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
Files, Attachments And Notes Salesforce Lightning Components | Force.com
Download Notes & Attachments from Force.com Site of Lightning Component Create an email alert that will be sent to the Opportunity Owner. This email will…
Know How To Display Parent Fields Value On A Standard Lightning Data Table
As we all know lightning data table has a limitation in directly displaying parent fields value related to the child object. However, we have a…
How Salesforce Financial Services Cloud Solves Problems For FinTech Companies
Working in the financial services industry is not an easy-breezy thing to do. It is all about managing people’s wealth and helping them plan their lives, literally.…
Popular Salesforce Videos
Pros & Cons of Lightning Component vs. 3rd party frameworks in Salesforce UI development
Nikita drops by to share his invaluable experience of using popular 3rd party frameworks in Salesforce. http://media.blubrry.com/salesforceway/audio.xmcdn.com/group42/M05/25/57/wKgJ81rXk6XjaZIAAU_I_KtprFM998.m4a
Makes Migration Between Salesforce Org Easy Using BOFC Application
BOFC has empowered global organizations by simplifying one of the biggest challenges in Salesforce migration, i.e., metadata management. In the above one got to know…
Salesforce Trailhead Bootcamp - Fast Track your Salesforce Certification - $700 OFF LIMITED TIME
If want to fast track the path to your Salesforce Administrator Certification then this video is for you! This offer includes your $200 Certification Voucher…
