Salesforce Validation Rules 19 | Validations | REGEX | Wild Card Characters | Validate Group of

Characters, Numbers, Words, Words with Specific Characters | [phone]
#SalesforceValidationRules #REGEXWildCardCharacters #ValidateWordsCharactersNumbers 19 By Swapna @ Swapna Salesforce [phone]
Flows Session Links
*(Validation Rules, Validations, REGEX, Wild Card Characters, Validate Group of Characters, Numbers, Words, Words with Specific Characters)
19. • Salesforce Validation ...
(Validation Rules, Raise Case to Team, Raise Ticket to Support Team, Contact, Case, Condition)
18. • Salesforce Validation ...
(Validation Rules, Functions, PriorValue, IsPickVal, IsNew, IsChanged, AND, OR, NOT)
17. • Salesforce Validation ...
*(Validation Rule, Governer Limits, Client Side Validation, Server Side Validation, Deactivate Validation Rule, Pre Defined Funtion, Error Message,
IsBlank, IsNull)*
16. • Salesforce Validation ...
15. • Salesforce Lightning F...
14. • Salesforce Lightning F...
13. • Salesforce Lightning F...
12. • Salesforce Lightning F...
11. • Salesforce Lightning F...
10. • Salesforce Lightning F...
09. Not Recorded
08. • Salesforce Lighnting F...
07. • Salesforce Lightning F...
06. • Salesforce Lightning F...
05. • Salesforce Lightning F...
04. • Salesforce Lightning F...
03. • Salesforce Adv Admin 0...
02. • Salesforce Adv Admin 0...
01. • Salesforce Advanced Ad...
***
Advanced Admin :
Validation Rules
IF(CreatedDate=Today, IsPickval(Rating,Warm), NOT(IsPickval(Rating,Warm))
REGEX(FieldName,'RegularExpression')
Wild card characters :
[] -- represents a croup of characters
[0-9] -- it represents the numbers, which has been prepared by using the Digists between 0-9
[A-R] -- it represents the words, which has been prepared by using the characters exist in between A-R
[a-p] -- it represents the words, which has been prepared by using the characters exist in between a-p
[s p r] -- it represents the words, which has been prepared by using these specific characters
PAN Number :
ALPPG7878E
----------
5 4 1
[A-Z, a-z]5[0-9]4[A-Z, a-z]1
Phone Number :
is Phone number : is all numerice or not ?
lengh
[0-9]10
9662460161
([0-9]3)[]1[0-9]3-[0-9]4
\\([0-9]3\\) [0-9]3-[0-9]4
[phone]
Created Date(Date/Month/year) : record is create , Jan to April
case still open (status!=closed)..
these old cases .. please close the status .. reopen whenever it is need
if(isPickval(stageName , "Prospecting"), Probability!=100,
else if (isPickval(stageName , "Qualification"), Probability!=0,
else if (isPickval(stageName , "Needs Analysis"), Probability!=10,
else if (isPickval(stageName , "case1"), Probability!=20,
else if (isPickval(stageName , "case2"), Probability!=30,
)
))
Probability*100!=
Case (stagName, "Prospecting", 100,
"Qualification",0,
"Needs Analysis",10,
"case1",20,
"case2",30,
100);
AND(Amount 1000,
CASE(StageName,
"Prospecting",1,
"Qualification",1,
"Need Analaysis",1,
0)=1
)
***
Assignment :
1. Prerequisites :
Create a Record Type on Account
Business Account
Individual Account
New Account
Fleet Account
Business2 Account
Create Active check box
Implement a validation rule if Account Record Type is "Business Account"
or "Business2 Account" or "Fleet Account"
then the Account has to have Active flag checked
2.Implement a validation rule, whenever Case is created ord Edit, Description
field should be required based on Case Reason picklist value selection
Case Reason : Installation
Performance
Breakdown
3.Implement a validation Rule to validate the Fax number and fire this
validation all the profiles except system admin chatter
4.Pre-request : create a Record Type : New Vehicle Lead , Old Vehicle Lead
Implement a validation Rule on creation of New Vehicle lead then Lead source has be other
5.Pre-request : create a a field on User Record
Ready to create a Record (checkbox):
create new Object : Patent
Fields : First Name
Last Name
Email
Phone
Implement a validation rule When user has "Ready to create a Record"
true then create new Patient record
6.Create a Field in "Valdation" Custom Object for the following Validate the Input Display the Masked Output in the Screen using Visualforce
1.SSN(Social Security Number) (XXXX XXXX 1234 - Last Four Digits should be Displayed)
2.PAN Number for Individual(**** 12- Last 2 Digits should be Displayed)
3.Passport Number (**** 12- Last 2 Digits should be Displayed)
4.Adhar (XXXX XXXX 1234 - Last Four Digits should be Displayed)
5.Date(MM/DD/YYYY)
Interview Questions
01.Explain REGEX(FieldName,'RegularExpression')?
02.What are the different Wild card characters used in Validations?
03.How to Validate Group of characters, Give Examples?
04.How to validate numbers, Give Examples?
05.How to validate words, Give Examples?
06.How to validate the words with specific characters, Give Examples?
Trailhead :
trailhead.salesforce.com/cont...

[@jineeths4731]

Can we create validation rule to display only day and month in birthdate field of contact object, please give suggestion

[@nagalakshmigona3734]

Mam can u pls tell validation rule for phone nb only starting with 6or 7 or 8 or 9 and length must be 10

[@parvinderpuri900]

I need to restricted any digit repeated 8 times in phone number how can i do this?

[@divyamanjula4351]

Hi mam
May i know the answers for the assignment given in this video

[@srivalligodavarthi9109]

omg where s the next vedio ? i searched in ur belog.but i didnt find it . ur about to explain the topic security features.

[@chandrasekhargummadi]

Please Help Me,
I have created a picklist Field of State
Telangana
Andhra Pradesh
Kerala
Gujarath
and picklist field of PINCODE
500001
500002
400001
400002
.
please help me how can created a validation rule that when ever i select Telangana and andhra pradesh. , The PINCODE values must show only number with starts with500001 and 500002
and If i select KERALA AND GIJARATH the Picklist pincode field should shown only 400001 and 400002
Please help me how can we dealt with validation rule with which function

[@crazyvlogs2366]

use the concept of field dependency