-
How to create a Salesforce custom field to display data in a format, in a HTML Template?
I have a custom text field so I want to display data format like this “XXXXXXXXXX4567” in HTML Template how can we achieve this Please suggest
-
2 Replies
-
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 🙂
-
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 6 years ago by Neha.
-
This reply was modified 6 years ago by
Log In to reply.
Popular Salesforce Blogs
Salesforce AppExchange: A Complete Guide
Introduction Talking about Salesforce, it is a cloud-based software company that has headquarters in San Francisco, California. It provides an array of services for CRM…
Why Choose Salesforce CRM for the Hospitality Industry
Today, it's hard to imagine an industry with tougher competition than hospitality. Both small family-owned hotels and big-name international resort chains compete with each other…
Reimagine Your Salesforce CPQ Implementation On Demand
Most businesses today expect implementation resources to be On-Demand because of the agile development environment and overall cost factors that arise. A Salesforce implementation should…
Popular Salesforce Videos
How To Build a Kanban View Using LWC without APEX | Real-Time Project in LWC | Salesforce
In this project, you will learn 60% of the LWC. You gonna learn the following topics 1. How to create a lightning Page 2. How…
Which Objects are in the Salesforce Sales Cloud and Service Cloud?
Salesforce comes with a large number of standard objects that are integral to Salesforce, but you can also create custom objects. We’ve compiled a list…
Happy 2021 to the Salesforce Ohana
As 2020 comes to a close, the challenges of the past year give way to hopes of a new year full of love, cheer, &…
