UtkarshaPravin SFDC BlogSpot

Using iFrame in lightning component to embed visualforce page (clickjack protection is enabled) Lighting Component: HZN_CohortImport.cmp <aura:component description="HZN_CohortImport" implements="force:appHostable" access="global">     <iframe src="/apex/HZN_CohortImport" width="100%" height="1000px;" frameBorder="0"/> </aura:component> Visualforce Page: HZN_CohortImport.page <apex:page id="HZN_CohortImport" showHeader="false" sideBar="false" controller="HZN_CohortImportController" lightningStylesheets="true" docType="html-5.0"> </apex:page> Add visualforce page in lightning component using iframe tag. iframe tag have some limitations, it will work only when clickjack protection is disabled. When clickjack protection is enabled visualforce page appear as a blank screen. To avoid this issue add your organization ur...

Concatenation using formula field I want to concatenate four fields in formula field with comma separated value. This is not possible as with normal concatenation you will see additional comma if one of the value is blank. You have to use different combination to achieve this but it will be lengthy process. Suppose, FirstName__c = Utkarsha                  SecondName__c = Pravin ThirdName__c = Raj FourthName__c = Rutuja Then I want if all are blank then show null value else Utkarsha, Pravin, Raj, Rutuja Suppose ThirdName__c is blank then it will show Utkarsha, Pravin, Rutuja I have used SUBSTITUTE functionality to achieve this. IF( AND(ISBLANK(FirstName__c),ISBLANK(SecondName__c),ISBLANK(ThirdName__c),ISBLANK(FourthName__c)),  NULL, SUBSTITUTE(     IF(         NOT(ISBLANK(FirstName__c)),         FirstName__c+ ", ",         NULL...