SivaAPSFDC

  1.LWC Short Keys VS Code Extension for  #Salesforce 2. pmd

  However it’ll not exclude the HOLIDAYS, Because each org has its own holidays based on region /country. Hence salesforce don’t have knowledge about list of holidays. CASE(MOD( StartDate__c – DATE(1985,6,24),7),    0 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),    1 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),    2 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),    3 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),    4 , CASE( MOD( EndDate__c – StartDate__c ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),    5 , CASE( MOD( EndDate__c – StartDate__c ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),    6 , CASE( MOD( EndDate__c – StartDate__c ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),    999)    +    (FLOOR(( EndDate__c – StartDate__c )/7)*5)  Steps to create: Create a formula fi...

 Contact Trigger : ================================================ trigger ContactTrigger on Contact ( after insert , after update , after delete , after undelete ) {     Set < Id > accountIds = new Set < Id >();     // Insert, Update (new AccountId), Undelete     if ( Trigger . isInsert || Trigger . isUpdate || Trigger . isUndelete ) {         for ( Contact con : Trigger . new ) {             if ( con . AccountId != null ) {                 accountIds . add ( con . AccountId );             }         }     }     // Delete, Update (old AccountId)     if ( Trigger . isDelete || Trigger . isUpdate ) {         for ( Contact con : Trigger . old ) {             if ( con . AccountId != null ) { ...

1. Check field-level permissions. 2. if you are sending from apex check, in soql those fields are mentioned. 3. check the template name if you are cloning some templates. 4. check HTML code in template if any conditional display.

  URL.getSalesforceBaseUrl().toExternalForm();

1. Create this class -------------------------------------------------------------------- public class EmailUtils {     public Static String removeInvalidDomain(String email) {         if (email != null && email.contains('@')) {             String[] parts = email.split('@');             String username = parts[0];             String domain = parts[1].toLowerCase();                          if (domain.endsWith('.invalid')) {                 domain = domain.substring(0, domain.length() - 8);             }                          return username + '@' + domain;         }                  return email; ...

Cron Expressions for Subscription Schedules  https://help.salesforce.com/s/articleView?id=sf.reports_subscription_reporting_cron.htm&type=5 Run Scheduled Apex job only once https://help.salesforce.com/s/articleView?id=000382128&type=1