• Today Soch
  • NEWBIE
  • 0 Points
  • Member since 2023

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies

I'm trying to create a Classic Email Template formula that shows a different value based on what's in the Plan_Name__c field on the Work Order object. I've managed to get one IF statement working but additional ones are just resulting in a null value. I've also tried the CASE function but that doesn't work at all. The first example is the working one and the following two are the ones that aren't working. Thanks in advance!


{!IF(WorkOrder.Plan_Name__c="$84 Naked FibreClassic","84","0")}

 

{!IF(WorkOrder.Plan_Name__c = "$84 Naked FibreClassic", "84", IF(WorkOrder.Plan_Name__c = "$89 FibreClassic + Phone", "89", IF(WorkOrder.Plan_Name__c = "$99 Naked FibreMax", "99", IF(WorkOrder.Plan_Name__c = "$104 FibreMax + Phone", "104", "0"))))}

 

{!CASE(WorkOrder.Plan_Name__c, "$84 Naked FibreClassic", 84, "89 FibreClassic + Phone", 89, "$99 Naked FibreMax", 99, "$104 FibreMax + Phone", 104, 0)}

Hello Salesforce Experts,

 

Anyone please let me know how to write valition rule for URL ?

Else someone please provide regular expression string for URL ?

 

Thanks,