You need to sign in to do that
Don't have an account?
![Siva Admin Siva Admin](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Add error while entering record with some name ending with, say for example, 'Text' eg: 'JohnText'
Hello all, I'm newly learning SF working on this requirement. It follows like this:
While inserting a text value as 'someName' ended with 'text' ex: 'JohnText' On Account Object it should through an error.
While updating, the same text value as 'JohnText' should accept it.
How to achive this? Kindly help.
While inserting a text value as 'someName' ended with 'text' ex: 'JohnText' On Account Object it should through an error.
While updating, the same text value as 'JohnText' should accept it.
How to achive this? Kindly help.
You can implement above scenario via two possible and simple approach:
1. Make Account Last Name field as unique. (setup --> Account --> Fields --> edit Last Name and make it unique)
2. Add validation rule on Account field, to make it unique.
Thanks,
Gaurav
Email: gauravgarg.nmims@gmail.com
In Validation rule just put below code in error condition formula and your desired error message in error message textbox of validation rule :
Let me know if you need more input from myside.
Thanks,
Vishal
Replace TEXT with the required text that you want to match
Replace the number 4 with the length of that text.