Platform App Builder Flashcards
ADDMONTHS
Returns the date that is the indicated number of months before or after a specified date.
BEGINS
Determines if text begins with specific characters and returns TRUE if it does. FALSE if not. (BEGINS, text, compare_text)
BLANKVALUE
Determines if an expression has a value and returns a substitute expression if it doesn’t. If the expression has a value, returns the value.
BR
Inserts a line break in a string of text.
CASE
Checks 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.
CASESAFEID
Converts a 15-character ID to a case-insensitive 18-character ID.
CONTAINS
Compares two arguments of text and returns TRUE if the first argument contains the second argument. If not, return FALSE.
CURRENCYRATE
Returns the conversion rate to the corporate currency for the given currency ISO code. If the currency is invalid, returns 1.0.
DATE
Returns a date value from year, month, and day values you enter.
DATEVALUE
Returns a date value for date/time or text expression.
DATETIMEVALUE
Returns a year, month, day, and GMT time value of a date/time field.
DISTANCE
Calculates the distance between two locations in miles or km.
FIND
Returns the position of a string within a string of text represented as a number.
INCLUDES
Determines if any value selected in a multi-select picklist field equals a text literal you specify.
LEFT
Returns the specified number of characters from the beginning of a text string.
LEN
Returns the number of characters in a specified text string.