-
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 7 years ago by Neha.
-
This reply was modified 7 years ago by
Log In to reply.
Popular Salesforce Blogs
Develop in Production: Insane or Inspired?
Accelerating implementation We all know the benefits of accelerating and streamlining the release cycle; the business is more agile and reduced development effort. But there…
How to Use Salesforce Chatter Better?
Here are 3 main STEPS, by which you can use SALESFORCE chatter more efficiently. Take a look… STEP 1: Follow relevant people and data Keep…
8 Ways a Salesforce LMS Integration Can Improve Customer Training
Integrating an LMS with Salesforce is beneficial as an LMS acts as a database of learning resources for your salesperson. It can also provide your employees with the band the positive behaviors…
Popular Salesforce Videos
Power of Personal Brand | The Shrey Sharma Show | Salesforce
Shrey is a Chief Executive Officer at Cyntexa, a SILVER Salesforce Consulting Partner in the USA, UK, UAE, Australia, Singapore & India, having a vibrant…
Get a Complete View of Salesforce Data with MongoDB
Teri will show you how you can incorporate Salesforce (relational data) into a MongoDB collection (non-relational data) to give your customers a unified customer experience.…
Salesforce Interface Sends a Command With Parameters to UiPath Assistant Using JavaScript
Salesforce interface sends a command with parameters to UiPath Assistant using Robotjs Code: https://github.com/cristinegulescu/startUiPathFromSalesforce/blob/master/SalesForceLocal.txt
