Skip to main content

Challenge: User Text Formulas

https://trailhead.salesforce.com/content/learn/modules/advanced_formulas/text_formulas

 

Message Error: Challenge not yet complete in Data modeling 2 Playground

We created a new lead with a value for company, but not email, phone, title, or industry. We expected it to have the '1 star' image but it didn't. If you use a CASE() function, make sure it’s positioned outside the IMAGE() function.

 

Additional Message Error: Email received when trying again. I do not understand its meaning. It mentions Flows!!?

 

De: "FlowApplication" <info@emea.salesforce.com>

À: "Christine GUTIERREZ" <cma.gutierrez@free.fr>

Envoyé: Jeudi 3 Août 2023 16:30:34

Objet: Error Occurred During Flow "Check New Lead for Matching Account": Probably Limit Exceeded or 0 recipients

Debug the failed interview in Flow Builder for the interview GUID: 693f933ed5e88c387d2511a6705189bbaf1bd4-1fd0

Error element Email_Lead_Routing (FlowActionCall).

Probably Limit Exceeded or 0 recipients

Many thanks for your kind help :)

 

C.

3 réponses
  1. 3 août 2023, 21:19

    Hi @Christine Gutierrez ,

     

    Try this

     

    For the Lead Quality Helper to work:

    IF(ISBLANK(Email), 0, 1) +

    IF(ISBLANK(Phone), 0, 1) +

    IF(ISBLANK(Company), 0, 1) +

    IF(ISBLANK(Title), 0, 1) +

    IF(ISPICKVAL((Industry),""), 0 ,1)

    For the Lead Quality to use the values correctly from the helper, the IMAGE needs to be inside the CASE instead of the example in the lecture:

     

    CASE(Lead_Quality_Helper__c,

    0, IMAGE("/img/samples/stars_000.gif","0 stars"),

    1, IMAGE("/img/samples/stars_100.gif", "1 star"),

    2, IMAGE("/img/samples/stars_200.gif", "2 stars"),

    3, IMAGE("/img/samples/stars_300.gif", "3 stars"),

    4, IMAGE("/img/samples/stars_400.gif", "4 stars"),

    5, IMAGE("/img/samples/stars_500.gif", "5 stars"),

    "Unknown")

0/9000