Checklist of All Obtainable Formulation For Salesforce Circulation

Title Label Description ExampleString 1 ABS ABS Returns absolutely the worth of a quantity, a quantity with out its signal ABS(quantity) 2 ACOS ACOS Returns the arc cosine of the quantity in radians, if the given quantity is between -1 and 1. In any other case NULL. ACOS(quantity) 3 ADDMONTHS ADDMONTHS Add the num months to the date, utilizing the final date of the month if date is the final day of the month or including num months has fewer days. ADDMONTHS(date,num) 4 AND AND Checks whether or not all arguments are true and returns TRUE if all arguments are true AND(logical1,logical2,…) 5 ASCII ASCII Return the primary character’s code level from the given string as a quantity. ASCII(textual content) 6 ASIN ASIN Returns the arc sine of the quantity in radians, if the given quantity is between -1 and 1. In any other case NULL. ASIN(quantity) 7 ATAN ATAN Returns the arc tangent of the quantity in radians. ATAN(quantity) 8 ATAN2 ATAN2 Returns the arc tangent of the quotient of y and x in radians. ATAN2(y, x) 9 BEGINS BEGINS Checks if textual content begins with specified characters and returns TRUE if it does. In any other case returns FALSE BEGINS(textual content, compare_text) 10 BLANKVALUE BLANKVALUE Checks whether or not expression is clean and returns substitute_expression whether it is clean. If expression just isn’t clean, returns the unique expression worth. BLANKVALUE(expression, substitute_expression) 11 BR BR Inserts an HTML break tag in string formulation BR() 12 CASE CASE Checks an expression in opposition to a sequence of values.  If the expression compares equal to any worth, the corresponding result’s returned. If it isn’t equal to any of the values, the else-result is returned CASE(expression, value1, result1, value2, result2,…,else_result) 13 CASESAFEID CASESAFEID Converts a 15-character ID right into a case insensitive 18-character ID CASESAFEID(id) 14 CEILING CEILING Rounds a quantity as much as the closest integer, away from zero if adverse CEILING(quantity) 15 CHR CHR Return a string with the primary character’s code level because the given quantity. CHR(quantity) 16 CONTAINS CONTAINS Checks if textual content comprises specified characters, and returns TRUE if it does. In any other case, returns FALSE CONTAINS(textual content, compare_text) 17 COS COS Returns the cosine of the quantity, the place the quantity given in radians COS(quantity) 18 CURRENCYRATE CURRENCYRATE Return the conversion price to the company forex for the given CurrencyIsoCode, or 1.zero if the forex is invalid. CURRENCYRATE(IsoCode) 19 DATE DATE Creates a date from a yr, month and day DATE(yr,month,day) 20 DATETIMEVALUE DATETIMEVALUE Returns a yr, month, day and GMT time worth DATETIMEVALUE(expression) 21 DATEVALUE DATEVALUE Creates a date from its datetime or textual content illustration DATEVALUE(expression) 22 DAY DAY Returns the day of the month, a quantity between 1 and 31 DAY(date) 23 DAYOFYEAR DAYOFYEAR Return the day of the calendar yr (from 1-366). DAYOFYEAR(date) 24 DISTANCE DISTANCE Returns the gap between two areas utilizing the supplied unit. DISTANCE(location, location, unit) 25 EXP EXP Returns e raised to the facility of a given quantity EXP(quantity) 26 FIND FIND Returns the place of the search_text string in textual content FIND(search_text, textual content [, start_num]) 27 FLOOR FLOOR Rounds a quantity down, in the direction of zero to the closest integer FLOOR(quantity) 28 FORMATDURATION FORMATDURATION Format the variety of seconds with optionally available days, or the distinction between instances or dateTimes as HH:MI:SS. FORMATDURATION(numSeconds[, includeDays] | dateTime/time, dateTime/time) 29 FROMUNIXTIME FROMUNIXTIME Return the datetime that represents the given quantity because the seconds elapsed since 1 Jan 1970. FROMUNIXTIME(quantity) 30 GEOLOCATION GEOLOCATION Returns a location primarily based on the supplied latitude and longitude. GEOLOCATION(latitude, longitude) 31 GETSESSIONID GETSESSIONID Returns the present session ID. This can be helpful in hyperlinks to different functions that use salesforce.com credentials for authentication GETSESSIONID() 32 HTMLENCODE HTMLENCODE Encodes textual content and merge subject values to be used in HTML HTMLENCODE(textual content) 33 HYPERLINK HYPERLINK Creates a hyperlink HYPERLINK(url, friendly_name [, target]) 34 IF IF Checks whether or not a situation is true, and returns one worth if TRUE and one other worth if FALSE. IF(logical_test, value_if_true, value_if_false) 35 INCLUDES INCLUDES Determines if any worth chosen in a multi-select picklist subject equals a textual content literal you specify. INCLUDES(multiselect_picklist_field, text_literal) 36 INITCAP INITCAP Return the textual content as lowercase with first character of every phrase made uppercase. INITCAP(textual content) 37 ISBLANK ISBLANK Checks whether or not an expression is clean and returns TRUE or FALSE ISBLANK(expression) 38 ISNULL ISNULL Checks whether or not an expression is null and returns TRUE or FALSE ISNULL(expression) 39 ISNUMBER ISNUMBER Returns TRUE if the textual content worth is a quantity. In any other case, it returns FALSE. ISNUMBER(Textual content) 40 ISOWEEK ISOWEEK Return the ISO 8601 week quantity for the given date (from 1-53) in order that the primary week begins on monday. ISOWEEK(date) 41 ISOYEAR ISOYEAR Return the ISO 8601 week-numbering 4-digit yr for the given date in order that the primary day is a monday. ISOYEAR(date) 42 ISPICKVAL ISPICKVAL Checks whether or not the worth of a picklist subject is the same as a string literal ISPICKVAL(picklist_field, text_literal) 43 JSENCODE JSENCODE Encodes textual content and merge subject values to be used in JavaScript JSENCODE(textual content) 44 JSINHTMLENCODE JSINHTMLENCODE Encodes textual content and merge subject values to be used in JavaScript inside HTML tags JSINHTMLENCODE(textual content) 45 LEFT LEFT Returns the desired variety of characters from the beginning of a textual content string LEFT(textual content, num_chars) 46 LEN LEN Returns the variety of characters in a textual content string LEN(textual content) 47 LINKTO LINKTO Returns the HTML hyperlink ingredient for the chosen goal with optionally available inputs expressed as question parameters LINKTO(label, goal, id, [inputs], [no override]) 48 LN LN Returns the pure logarithm of a quantity LN(quantity) 49 LOG LOG Returns the bottom 10 logarithm of n LOG(quantity) 50 LOWER LOWER Converts all letters within the worth to lowercase LOWER(textual content) 51 LPAD LPAD Pad the left aspect of the worth with areas or the optionally available pad string in order that the size is padded_length LPAD(textual content, padded_length [, pad_string]) 52 MAX MAX Returns the best of all of the arguments MAX(quantity,quantity,…) 53 MCEILING MCEILING Rounds a quantity as much as the closest integer, in the direction of zero if adverse MCEILING(quantity) 54 MFLOOR MFLOOR Rounds a quantity all the way down to the closest integer, away from zero if adverse MFLOOR(quantity) 55 MID MID Returns character from the center of a textual content string, given a beginning place and size MID(textual content, start_num, num_chars) 56 MIN MIN Returns the least of all of the arguments MIN(quantity,quantity,…) 57 MOD MOD Returns the rest after a quantity is split by a divisor MOD(quantity,divisor) 58 MONTH MONTH Returns the month, a quantity between 1 (January) and 12 (December) MONTH(date) 59 NOT NOT Adjustments FALSE to TRUE or TRUE to FALSE NOT(logical) 60 NOW NOW Returns a datetime representing the present second NOW() 61 NULLVALUE NULLVALUE Checks whether or not expression is null and returns substitute_expression whether it is null. If expression just isn’t null, returns the unique expression worth. NULLVALUE(expression, substitute_expression) 62 OR OR Checks whether or not any of the arguments are true and returns TRUE or FALSE. Returns FALSE provided that all arguments are false OR(logical1,logical2,…) 63 PI PI Returns pi PI() 64 PICKLISTCOUNT PICKLISTCOUNT Returns the variety of chosen values in a multi-select picklist. PICKLISTCOUNT(multiselect_picklist_field) 65 PREDICT PREDICT Returns an Einstein Discovery prediction primarily based on both a file ID or an inventory of fields and their values. PREDICT(PredDefId, [recordId] | [field, value, …]) 66 REGEX REGEX Returns TRUE if Textual content matches the common expression RegEx_Text. In any other case, it returns FALSE. REGEX(Textual content, RegEx_Text) 67 REVERSE REVERSE Returns the textual content string in reverse order REVERSE(textual content) 68 RIGHT RIGHT Returns the desired variety of characters from the tip of a textual content string RIGHT(textual content, num_chars) 69 ROUND ROUND Rounds a quantity to a specified variety of digits ROUND(quantity,num_digits) 70 RPAD RPAD Pad the suitable aspect of the worth with areas or the optionally available pad string in order that the size is padded_length RPAD(textual content, padded_length [, pad_string]) 71 SIN SIN Returns the sine of the quantity, the place the quantity given in radians SIN(quantity) 72 SQRT SQRT Returns the constructive sq. root of a quantity SQRT(quantity) 73 SUBSTITUTE SUBSTITUTE Substitutes new_text for old_text in a textual content string. Use SUBSTITUTE while you need to change particular textual content in a textual content string SUBSTITUTE(textual content, old_text, new_text) 74 TAN TAN Returns the tangent of the quantity, the place the quantity given in radians TAN(quantity) 75 TEXT TEXT Converts a price to textual content utilizing normal show format TEXT(worth) 76 TODAY TODAY Returns the present date TODAY() 77 TRIM TRIM Removes all areas from a textual content string aside from single areas between phrases TRIM(textual content) 78 TRUNC TRUNC Truncates a quantity to a specified variety of digits TRUNC(quantity,num_digits) 79 UNIXTIMESTAMP UNIXTIMESTAMP Return the variety of seconds since 1 Jan 1970 for the given date, or variety of seconds within the day for a time. UNIXTIMESTAMP(date/time) 80 UPPER UPPER Converts all letters within the worth to uppercase UPPER(textual content) 81 URLENCODE URLENCODE Encodes textual content and merge subject values to be used in URLs URLENCODE(textual content) 82 URLFOR URLFOR Returns the url for the chosen goal with optionally available inputs expressed as question parameters URLFOR(goal, id, [inputs], [no override]) 83 VALUE VALUE Converts a textual content string that represents a quantity to a quantity VALUE(textual content) 84 WEEKDAY WEEKDAY Return the day of the week for the given date, utilizing 1 for Sunday, 2 for Monday, by means of 7 for Saturday. WEEKDAY(date) 85 YEAR YEAR Returns the yr of a date, a quantity between 1900 and 9999 YEAR(date)