Rollup-Summary: 

Rollup summary fields are often created only on master objects in master-detail relation. Rollup summary is used for applying aggregate functions on corresponding child records.

Count():  This will return count of the number of records of children which are participating in the rollup operation.

sum(Number/Currency/ Percent): This is utilized or used to make the summarized value of given child records participating within the rollup.

Max(Number/Currency/Percent/Date/DateTime):  This is used to return the maximum value from the corresponding child records participating within the rollup operation.

MIN(Number/Currency/Percent/Data/DateTime): 

  • This will return the minimum value from the corresponding child record which is participating within the rollup operation. 
  • We can create the filter condition to specify which child records should participate within the rollup operation.
  • Allow all the child records:
  • If this is chosen all the records of the child of the master record will participate within the relation.
  • Allow only those records of child which are meeting the filter condition: 
  • If this is chosen, only those child records which are meeting the filter condition can participate within the relation. We can create 25 rollup summary fields on an object.

FORMULA:

ISNULL(expression):

1. If the value of the expression is null then return true.

2. If the value of the expression is not null then return false.

3. Example:

ISNULL(10):  false

4. This is used on numerical values 

ISBLANK(expression):

1. If the value of the expression is blank then it will return true.

2. If the value of the expression is not blank then it will return false.

3. This is used for text fields.

4. Example :

ISBLANK(FirstName)

ISBLANK(Email)

ISBLANK(‘Satish’): false

IF(Condition ,stmt1, stmt2 ):

1. If the condition is true,then stmt1 will be returned.

2. if the condition is false,then stmt2 will be returned.

3. Example :

IF(Salary__c > 50000 ,’SFDC’,’JAVA’)

IMAGE(URL,errorMsg):

1.This will print image associated with given url

2.If the url is not working errorMessage will be displayed.

Static Resource:

1.Click on Setup

2.Click on Build

3.Click on Develop

4.Click on Static Resource

5.Click on New Static Resource

6.Enter Resource Name 

7.Choose the resource

8.Save 

9.Click on view file and copy the url

DATE Functions:

DATE(YYYY,MM,DD): This will create a instance of a date 

DATE(2018,10,12)

DATEVALUE(expression):  

This will convert the datetime into date 

DATEVALUE(CreatedDate)

DAY:

This will return day from the given date 

DAY(DATE(2018,2,23) ) : 23 

MONTH:

This will return month from the given date 

MONTH(DATE(2018,2,23) ) : 2 

YEAR:

This will return year from the given date 

YEAR( DATE(2018,2,23)) : 2018

TODAY():

This will return today’s date 

NOW():

This will return current date and time

AND(cond1,cond2,cond3…..):

If all the conditions are true, they will return true

AND( Age__c> 40 , Salary__c > 50000)

OR( cond1,cond2,Con3…..); 

If one or more conditions are true then they are returning true

OR( cond1,cond2,cond3….)

OR( Age__c > 40 ,Salary__c > 50000 )

NOT(cond):

1. If the condition is true ,then it will return false.

2. If the condition is false then it will return true.

ISNUMBER (value): 

It will return true ,if the given value is a number.

BEGINS(Text,searchText):

This will return true, if the text starts with searchText

Example : BEGINS(‘ABCD’,’AB’) : true

CONTAINS(Text,searchText): 

This will return true, if the text contains the searchText

Example : CONTAINS(‘HYD:BAN:CHE:PUNE’,’BAN’): true

FIND(searchText,text): 

This will return index at which first occurrence of searchText in the text

FIND(‘ABC’,’AXYABCUYYYABC’): 3 

HYPERLINK(url,link name,target):

Linkname will be displayed ,when we click on the link corresponding page is opened.

Target specifies where the page should be opened.

HYPERLINK(‘https://www.facebook.com’,’Facebook’);

LEFT(Text,Number): 

This will return given number of characters from left side of the text

Example : LEFT(‘ABCDEF’,2): AB 

RIGHT(Text,Number):

This will return given number of the characters from right side of the text 

Example: RIGHT(‘ABCDEF’,2) : EF

LPAD(Text,length,symbol):

LPAD(‘ABCD’,6,’*’)==== > ** ABCD

RPAD(‘ABCD’,6,’*’) ====> ABCD **

Leave a Reply

Your email address will not be published. Required fields are marked *