Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › How to create a Salesforce custom field to display data in a format, in a HTML Template?

Tagged: , , , , , , , ,

  • Adarsh

    Member
    March 27, 2018 at 10:47 AM

    Hi J,

    HTML templates can only display basic fields. So, you would need a formula field:

    MaskedCustomTextField__c (Text) =
    LPAD(CustomTextField__c,LEN(CustomTextField__c)-4,"X") &
    RIGHT(CustomTextField__c,4)
    Put the formula field into the HTML template, and you're good to go:

    {!Account.MaskedCustomTextField__c}
    If you use a Visualforce template, you can put it directly in to your text:

    {!LPAD(CustomTextField__c,LEN(CustomTextField__c)-4,"X") &
    RIGHT(CustomTextField__c,4)}

     

    Hope it helps 🙂

  • [adinserter block='9']

  • Neha

    Member
    March 27, 2018 at 11:02 AM

    HTML templates can only display basic fields. So, you need to create a formula field:

    EncryptedField__c Formula's:

    LPAD((RIGHT(CustomTextField__c,4)),LEN(CustomTextField__c),"X")

    Put the formula field into the HTML template, and you're good to go:

    {!Account.EncryptedField__c }

    I have validated with Phone field on Account and it works for me. Hope this helps you too.

    • This reply was modified 8 years, 7 months ago by  Neha.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos
Salesforce Interview Questions and Answers - For Freshers and Experienced Candidates

Salesforce Interview Questions and Answers - For Freshers and Experienced Candidates

Video in Salesforce Stories, Salesforce Training

Learn most important Salesforce Interview Questions and Answers, asked at every interview. These Interview questions will be useful to all entry-level candidates, beginners, interns, and…

Salesforce Developers, Salesforce Training Video, Salesforce Interview Questions, Interview Questions and Answers, Salesforce Interview Questions and Answers
Neha Yadav Jun 2, 2020
2,029  Views