Salesforce Regex Validation Rule in International Format

Create validation rule on phone or mobile field on any Account or Contact object on salesforce.Then it will check for whether phone number is given as empty or given in proper format or not.

NOT(REGEX( Phone , "^\\s*(?:\\+?(\\//*|\\d{1,3}))?([-. (\\d*]*(\\d{3})[-. )]*)?((\\d{3})[-. ]*(\\d{2,4})(?:[-.x ]*(\\d+))(?:\\s*(?:#|\\//*|\\\\|,|-| |x|\\|.?|ext\\.?|extension\\.?|\\*)*([-. \\//\\\\(\\d*]*(\\d{1,4})[-. )]*)\\s*(\\d|#+))?)\\s*$"))

Useful Link : https://help.salesforce.com/articleView?id=000181563&language=en_US&type=1


Salesforce Validation Rule
Account Validation rule

Comments

Post a Comment

Popular posts from this blog

Community/Experience Cloud Interview Questions

  Community Cloud /Experience Cloud: 1) What is community cloud/Experience Cloud ? Community cloud is a platform to connect with customers, partners, and employees.customers can view records (case,order), share documents, images etc.We can directly communicate with Agents to resolve problems. Community cloud renamed as Experience Cloud in Spring 21. From now community Builder,community workspace called as Experience Builder and Experience workspace. 2) May i know Spring 21 major updates about terminology in community/Experience cloud? Below are the major updates given by salesforce in Community cloud. Community cloud changed to Experience Cloud Community changed to Site or Experience Cloud site Lightning community changed to Experience Builder Site Lightning community template changed to Experience Builder template Lightning community theme changed to Experience Builder theme Lightning community page changed to Experience Builder page Salesforce Tabs + Visualforce community chang
Read more

Script to delete multiple records using Apex salesforce

Delete multiple records from salesforce anonymous block using some script.find the below script just paste the script in the anonymous vlock and select the code and click on Execute Highlighted. Before that if any conditions need to check add it in SOQL Query or if condition then it will filter the records and delete the records. If there are more records we have to run this script multiple times .if we try to delete all the records at a time we might get the DML and limit exceptions.so adding limit in SOQL query and executing. Example :  Object : ABC__c Fields : field1__c, field2__c list<ABC__c> abclist = new list<ABC__c>(); List<ABC__c > alltldroles = [SELECT id,name,field1__c,field2__c                              FROM ABC__c LIMIT 1000]; if(alltldroles.size()>0){     for(ABC__c tldroleslist : alltldroles) {          if(tldroleslist.field1__c != null && tldroleslist.field2__c!=null )  {           abclist.add(tldroleslist);       }
Read more

Change Owner / Update record using Lightning Custom Button Salesforce

Image
This post is related to changes the Owner or update the record from detail page in lightning. Actually we have standard button to change the owner of the record but when we click on the lighting button it will populate the popup and ask for user to change. But here the requirement is change the logged in user direcly when we click on the button. So here we created Custom lightning component with custom Quick action to complete this task. Standard Change Owner in Lightning In classic saleforce we used custom javascript buttons to execute the functionalites but lighting not support the javascript so here we created custom component with Quick action and added in the pagelayout so we can see it in lighting.and add the button in "Salesforce Mobile and Lightning Experience Actions" section. Add caption Lightning Button Pagelayout Change owner Lightning Button  <!--change owner lighting Component --> Component Name : changeowner.cmp <aura
Read more