Skip to main content
Topics#Lightning ExperienceAnna Jordan の質問
Anna Jordan が「#Lightning Experience」で質問
2015年8月26日 17:05

Lightening Process Builder - Help on a criteria formula?

Hello!  I'm having the weirdest problem with the Lightening Process Builder.

I'm attempting to create a Process that flags Leads based on certain values in a text field called Lead.External_ID__c. Whenever I save the criteria node, I get the error message: The formula expression is invalid: Syntax error.  (Formula below: "Criteria Formula - External ID")

The weird part is that I have another process with a very very similar formula, but with a different field (Zip Code) and different values.  

If I copy that formula exactly, and switch out the field Zip Code for the field External ID, the new formula works (but evaluates an External ID against zip codes, which isn't useful).  Once I start switching out the values, I get the error message.  However, if I switch the values out one by one and save the process in between, it sometimes works.

Perhaps someone can help? (I know my code probably isn't pretty - I'm more an admin than a developer).

Criteria Formula - External ID (shortened here for ease of reading - there are about 70 other values)

0 = CASE( Lead.External_ID__c ,

“4685", 1,

“4689", 1,

“4694", 1,

“4697", 1,

“4698", 1,

“4703", 1,

“4712", 1, 0)

Zip Code Formula that works (also shortened)

1==CASE([Lead].PostalCode , 

"35205", 1, 

"90706", 1, 

"90801", 1, 

"90804", 1, 

"79905", 1, 

"79925", 1, 

"79902", 1, 

"77025", 1, 

"77098", 1, 0)
5 件の回答
  1. William Tran (TranConsulting Inc (william@tranconsultinginc.com))
    2015年8月26日 17:09
    Replace this;

    0 = CASE( Lead.External_ID__c ,

    with this:

    0 == CASE( Lead.External_ID__c ,

    As a common practice, if your question is answered, please choose 1 best answer. 

    But you can give every answer a thumb up if that answer is helpful to you. 

    Thanks
回答を記入...
0/9000