• yogesh kherajani
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 4
    Replies
Hello, Our accounts are brought in from our data warehouse. In there, all account names are written in all uppercase (JOHN SMITH) I created a formula field that makes it proper case for email templates (John Smith). The problem is if someone entered the customer's first name as "JOHN & JANE" their name appears like this, "John & jane Smith" (j in Jane not being capitalized) Is there a way to fix this? Here is the code as it stands:

UPPER(MID(Order_Number__r.AccountId__r.FirstName, 1, 1))&LOWER( MID(Order_Number__r.AccountId__r.FirstName, 2,255)) &" "& UPPER(MID( Order_Number__r.AccountId__r.LastName, 1, 1))&LOWER( MID(Order_Number__r.AccountId__r.LastName, 2,255))

Thank you for any assistance! 
I am having a lot of trouble making my visualforce page a lightning component action on my custom object. Any help is greatly appreciated! My visualforce page is called DeliveryNew
​​​​​​​User-added image
User-added image