UI-Only LEN in equalion

  • 1
  • Question
  • Updated 2 years ago
  • Answered
What do I have wrong?

If (   LEN( {{Temp_10_Digits__c}}   )  ==  10
,
""
,
"The phone length is " & LEN({{Temp_10_Digits__c}}) & " digits, it needs to be 10 digits." 
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Bill,

I am not exactly sure, but I think the 'IF' must be uppercase and I don't think you can combine the LEN function along with text for the result if false.

I was able to do what you are after by creating a second formula field called 'PhoneMessage' that would display the message you want when the value is false.  Here are the formulas for my 2 fields:

PhoneCheck--> Formula field - Text output

IF(LEN({{Phone}})==10,"",{{PhoneMessage}})

PhoneMessage--> Formula field - Text output

"The phone length is " + LEN({{Phone}}) + " digits, it needs to be 10 digits."

Thanks,

Bill
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
Thnak Bill