-
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, 8 months ago by Neha.
-
This reply was modified 6 years, 8 months ago by
Log In to reply.
Popular Salesforce Blogs
Field Service Innovations with Einstein GPT and Salesforce CRM
Integrating cutting-edge technologies has become paramount in the rapidly changing environment of industries, where consumer satisfaction and operational effectiveness are crucial. The integration of Einstein…
Learn All About Salesforce Campaigns
What are Salesforce Campaigns A Salesforce Campaign is a group of Leads and Contacts exposed to specific marketing communication(s). It stores essential performance metrics and…
Look ups and Master Detail
We were done with just the two fields Auto Number and Formula Field, In this section we will move on and consider the other fields.…
Popular Salesforce Videos
Salesforce JavaScript Developer 2 Certification Series
Hi Everyone, SFDC Panther has started the Salesforce JavaScript Certification series and this is the second session of the series. I already have uploaded the…
Approval Process In Salesforce | Salesforce Development Tutorial
Approval process in Salesforce. This video will cover the following points - 1. Approval Process Learn how to create an approval process. 2. Manage Approval…
How to Delete Multiple Contacts at Once | Salesforce Tutorial
Do you need to delete a bunch of records? Don't want to delete records one by one? This video shows you several ways to delete…
