Types of Functions in Salesforce

Types of Functions in Salesforce

Use functions when building formulas. All functions are available everywhere that you can include a formula such as formula fields, validation rules, approval processes, and workflow rules, unless otherwise specified.


Types of Functions in Salesforce

  1. Date and Time Functions
  2. Logical Functions
  3. Math Functions
  4. Text Functions
  5. Summary Functions
  6. Advanced Functions

Date and Time Functions
FUNCTIONDESCRIPTION
ADDMONTHSReturns the date that is the indicated number of months before or after a specified date. If the specified date is the last day of the month, the resulting date is the last day of the resulting month. Otherwise, the result has the same date component as the specified date.
DATEReturns a date value from year, month, and day values you enter. Salesforce displays an error on the detail page if the value of the DATE function in a formula field is an invalid date, such as February 29 in a non-leap year.
DATEVALUEReturns a date value for a date/time or text expression.
DATETIMEVALUEReturns a year, month, day, and GMT time value.
DAYReturns a day of the month in the form of a number from 1 through 31.
DAYOFYEARReturns the day of the calendar year (from 1 through 366).
FORMATDURATIONFormats the number of seconds with optional days, or the difference between times or dateTimes as HH:MI:SS.
HOURReturns the local time hour value without the date in the form of a number from 1 through 24.
ISOWEEKReturns the ISO 8601-week number (from 1 through 53) for the given date, ensuring that the first week starts on a Monday.
ISOYEARReturns the ISO 8601 week-numbering year (in 4 digits) for the given date, ensuring that the first day is a Monday.
MILLISECONDReturns a milliseconds value in the form of a number from 0 through 999.
MINUTEReturns a minute value in the form of a number from 0 through 60.
MONTHReturns the month, a number between 1 (January) and 12 (December) in number format of a given date.
NOWReturns a date/time representing the current moment.
SECONDReturns a seconds value in the form of a number from 0 through 60.
TIMENOWReturns a time value in GMT representing the current moment. Use this function instead of the NOW function if you only want to track time, without a date.
TIMEVALUEReturns the local time value without the date, such as business hours.
TODAYReturns the current date as a date data type.
UNIXTIMESTAMPReturns the number of seconds since 1 Jan 1970 for the given date, or number of seconds in the day for a time.
WEEKDAYReturns the day of the week for the given date, using 1 for Sunday, 2 for Monday, through 7 for Saturday.
YEARReturns the four-digit year in number format of a given date.

Logical Functions
FUNCTIONDESCRIPTION
ANDReturns a TRUE response if all values are true; returns a FALSE response if one or more values are false.
BLANKVALUEDetermines if an expression has a value and returns a substitute expression if it doesn’t. If the expression has a value, returns the value of the expression.
CASEChecks a given expression against a series of values. If the expression is equal to a value, returns the corresponding result. If it isn't equal to any values, it returns the else_result.
IFDetermines if expressions are true or false. Returns a given value if true and another value if false.
ISBLANKDetermines if an expression has a value and returns TRUE if it doesn’t. If it contains a value, this function returns FALSE.
ISCLONEChecks if the record is a clone of another record and returns TRUE if one item is a clone. Otherwise, returns FALSE.
ISNEWChecks if the formula is running during the creation of a new record and returns TRUE if it is. If an existing record is being updated, this function returns FALSE.
ISNULL

Determines if an expression is null (blank) and returns TRUE if it is. If it contains a value, this function returns FALSE.


IMPORTANT Use ISBLANK instead of ISNULL in new formulas. ISBLANK has the same functionality as ISNULL, but also supports text fields. Salesforce continues to support ISNULL, so you don’t need to change any existing formulas.
ISNUMBERDetermines if a text value is a number and returns TRUE if it is. Otherwise, it returns FALSE.
NOTReturns FALSE for TRUE and TRUE for FALSE.
NULLVALUE

Determines if an expression is null (blank) and returns a substitute expression if it is. If the expression isn’t blank, returns the value of the expression.


IMPORTANT Use BLANKVALUE instead of NULLVALUE in new formulas. BLANKVALUE has the same functionality as NULLVALUE, but also supports text fields. Salesforce continues to support NULLVALUE, so you don’t need to change existing formulas.
ORDetermines if expressions are true or false. Returns TRUE if any expression is true. Returns FALSE if all expressions are false.
PRIORVALUEReturns the previous value of a field.


Math Functions
FUNCTIONDESCRIPTION
ABSCalculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.
ACOSReturns the arc cosign of the number in radians, if the given number is between -1 and 1. Otherwise returns NULL.
ASINReturns the arc sine of the number in radians, if the given number is between -1 and 1. Otherwise returns NULL.
ATANReturns the arc tangent of the number in radians.
ATAN2Returns the arc tangent of the quotient of y and x in radians.
CEILINGRounds a number up to the nearest integer, away from zero if negative.
CHRReturns a string with the first character’s code point as the given number.
COSReturns the cosine of the number in radians, if the given number is between -1 and 1. Otherwise returns NULL.
DISTANCECalculates the distance between two locations in miles or kilometers.
EXPReturns a value for e raised to the power of a number you specify.
FLOORReturns a number rounded down to the nearest integer, towards zero if negative.
FROMUNIXTIMEReturns the datetime that represents the given number as the seconds elapsed since 1 Jan 1970.
GEOLOCATIONReturns a geolocation based on the provided latitude and longitude. Must be used with the DISTANCE function.
LNReturns the natural logarithm of a specified number. Natural logarithms are based on the constant e value of 2.71828182845904.
LOGReturns the base 10 logarithm of a number.
MAXReturns the highest number from a list of numbers.
MCEILINGRounds a number up to the nearest integer, towards zero if negative.
MFLOORRounds a number down to the nearest integer, away from zero if negative.
MINReturns the lowest number from a list of numbers.
MODReturns a remainder after a number is divided by a specified divisor.
PIReturns pi.
PICKLISTCOUNTReturns the number of selected values in a multi-select picklist.
ROUNDReturns the nearest number to a number you specify, constraining the new number by a specified number of digits.
SINReturns the sine of the number, where the number is given in radians.
SQRTReturns the positive square root of a given number.
TANReturns the tangent of the number, where the number is given in radians.
TRUNCTruncates a number to a specified number of digits.

Text Functions
FUNCTIONDESCRIPTION
ASCIIReturns the first character’s code point from the given string as a number.
BEGINSDetermines if text begins with specific characters and returns TRUE if it does. Returns FALSE if it doesn't.
BRInserts a line break in a string of text.
CASESAFEIDConverts a 15-character ID to a case-insensitive 18-character ID.
CONTAINSCompares two arguments of text and returns TRUE if the first argument contains the second argument. If not, returns FALSE.
FINDReturns the position of a string within a string of text represented as a number.
GETSESSIONIDReturns the user’s session ID.
HTMLENCODEEncodes text and merge field values for use in HTML by replacing characters that are reserved in HTML, such as the greater-than sign (>), with HTML entity equivalents, such as >.
HYPERLINKCreates a link to a URL specified that is linkable from the text specified.
IMAGEInserts an image with alternate text and height and width specifications.
INCLUDESDetermines if any value selected in a multi-select picklist field equals a text literal you specify.
INITCAPReturns the text as lowercase with the first character of each word in uppercase.
ISPICKVALDetermines if the value of a picklist field is equal to a text literal you specify.
JSENCODEEncodes text and merge field values for use in JavaScript by inserting escape characters, such as a backslash (\), before unsafe JavaScript characters, such as the apostrophe (').
JSINHTMLENCODEncodes text and merge field values for use in JavaScript inside HTML tags by replacing characters that are reserved in HTML with HTML entity equivalents and inserting escape characters before unsafe JavaScript characters. JSINHTMLENCODE(someValue) is a convenience function that is equivalent to JSENCODE(HTMLENCODE((someValue)). That is, JSINHTMLENCODE first encodes someValue with HTMLENCODE, and then encodes the result with JSENCODE.
LEFTReturns the specified number of characters from the beginning of a text string.
LENReturns the number of characters in a specified text string.
LOWERConverts all letters in the specified text string to lowercase. Any characters that aren’t letters are unaffected by this function. Locale rules are applied if a locale is provided.
LPADInserts characters you specify to the left-side of a text string.
MIDReturns the specified number of characters from the middle of a text string given the starting position.
RIGHTReturns the specified number of characters from the end of a text string.
RPADInserts characters that you specify to the right-side of a text string.
SUBSTITUTESubstitutes new text for old text in a text string.
TEXTConverts a percent, number, date, date/time, or currency type field into text anywhere formulas are used. Also, converts picklist values to text in approval rules, approval step rules, workflow rules, escalation rules, assignment rules, auto-response rules, validation rules, formula fields, field updates, and custom buttons and links.
TRIMRemoves the spaces and tabs from the beginning and end of a text string.
UPPERConverts all letters in the specified text string to uppercase. Any characters that aren’t letters are unaffected by this function. Locale rules are applied if a locale is provided.
URLENCODEEncodes text and merge field values for use in URLs by replacing characters that are illegal in URLs, such as
blank spaces, with the code that represent those characters as defined in RFC 3986, Uniform Resource Identifier (URI): Generic Syntax. For example, blank spaces are replaced with %20, and exclamation points are replaced with %21.
VALUEConverts a text string to a number.

Summary Functions

The following functions are available with summary, matrix, and joined reports.

FUNCTIONDESCRIPTION
PARENTGROUPVALThis function returns the value of a specified parent grouping. A “parent” grouping is any level above the one containing the formula. You can use this function only in custom summary formulas and at grouping levels for reports, but not at summary levels.
PREVGROUPVALThis function returns the value of a specified previous grouping. A “previous” grouping is one that comes before the current grouping in the report. Choose the grouping level and increment. The increment is the number of columns or rows before the current summary. The default is 1; the maximum is 12. You can use this function only in custom summary formulas and at grouping levels for reports, but not at summary levels.

Advanced Functions
FUNCTIONDESCRIPTION
CURRENCYRATEReturns the conversion rate to the corporate currency for the given currency ISO code. If the currency is invalid, returns 1.0.
GETRECORDIDSReturns an array of strings in the form of record IDs for the selected records in a list, such as a list view or related list.
IMAGEPROXYURLSecurely retrieves external images and prevents unauthorized requests for user credentials.
INCLUDEReturns content from an s-control snippet. Use this function to reuse common code in many s-controls.
ISCHANGEDCompares the value of a field to the previous value and returns TRUE if the values are different. If the values are the same, this function returns FALSE.
JUNCTIONIDLISTReturns a JunctionIDList based on the provided IDs.
LINKTOReturns a relative URL in the form of a link (href and anchor tags) for a custom s-control or Salesforce page.
PREDICTReturns an Einstein Discovery prediction for a record based on the specified record ID or for a list of fields and their values.
REGEXCompares a text field to a regular expression and returns TRUE if there’s a match. Otherwise, it returns FALSE. A regular expression is a string used to describe a format of a string according to certain syntax rules.
REQUIRESCRIPTReturns a script tag with source for a URL you specify. Use this function when referencing the Lightning Platform AJAX Toolkit or other JavaScript toolkits.
URLFORReturns a relative URL for an action, s-control, Visualforce page, or a file in a static resource archive in a Visualforce page.
VLOOKUPReturns a value by looking up a related value on a custom object similar to the VLOOKUP() Excel function.


Follow Us

Posted By : Sudeer Kamat Date :

view_module Related

label Labels

Comments 0