Posts

flow true value

 {!$GlobalConstant.True}

LWC Datatable CSS Styling - column heading color change - data cell colur change on dynamic

 lwc data table heading  color change example https://techdicer.com/lwc-datatable-css-styling/

Developer productivity tools

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

Formula To Calculate The Number Of Days Between Two Dates While Excluding Weekends

  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...

rollup summary with bulk record handling without hitting governer limits

 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 ) { ...

Email Merge Fields missing - resoling

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.

get Salesforce base url using apex

  URL.getSalesforceBaseUrl().toExternalForm();