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 🙂

  • 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 ago by  Neha.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos
How to Learn Salesforce Development | Salesforce learning steps for beginners | Trailhead demo

How to Learn Salesforce Development | Salesforce learning steps for beginners | Trailhead demo

Video in Salesforce Training, Trailhead

In this video, we shared the steps to learn salesforce lightning basics, salesforce apex development, CRM in online for free from scratch very quickly. Learn salesforce…

Salesforce Training, Salesforce Tutorial, salesforce training videos for beginners, How To Learn Salesforce Development, Salesforce Learning Steps For Beginners
Shiv Kumar Sharma Jan 18, 2018
2,915  Views