-
Restricting characters and removing space at the end of a field?
I want to restrict the following characters ‘ “ , * % @ and if possible remove any extra spaces at the end of the field. , I don't really want to have to input every single charachter other than those listed above. Any guidence would greatly be appreciated.
-
1 Reply
-
Hi Tanu,
You can use this formula example to validate against usage of those special characters and checking if there are spaces at the end.
OR(
CONTAINS( Text_Field__c , "'"),
CONTAINS( Text_Field__c , '"'),
CONTAINS( Text_Field__c , ","),
CONTAINS( Text_Field__c , "*"),
CONTAINS( Text_Field__c , "%"),
CONTAINS( Text_Field__c , "@"),
CONTAINS(RIGHT(Text_Field__c, 1), " ")
)I hope this helps.
Log In to reply.
Popular Salesforce Blogs
All You Need To Know About Salesforce Health Cloud 2.0
Health Cloud 2.0, a solution designed to empower businesses and governments to provide better health and safety for their employees, consumers, and communities, was unveiled…
8 Salesforce Sales Cloud Tips To Boost Your Productivity and Drive Revenue
Tip 1: Stay on Top of your Customer’s Business What's it: Einstein-empowered experiences put significant client advancements upfront so you think about effects on their…
Influence of Salesforce on Non-Profit Organizations
Regardless of whether you are relieving kids, helping the old, sparing the earth or battling neediness, your nonprofit organization faces one major predicament. The difficulties…
Popular Salesforce Videos
Prepopulate Field values in Salesforce Lightning Experience Using defaultFieldValues
Prepopulate Field values in Lightning Experience Using defaultFieldValues - Spring 20 This video demonstrates the following items: Set Record Type Id Using defaultFieldValues Enforce User…
Apex Design Patterns : The Singleton Pattern in Salesforce || #Salesforce #DesignPatterns
The Singleton Pattern One Private variable of the class itself will hold the instance of the complete class so that we can access all the…
FlexDeploy for Salesforce
FlexDeploy can improve your enterprise software development, operations, and release processes using out-of-the-box support for Salesforce. See how FlexDeploy supports org-based development, source-driven development, or…
