Learning Airtable

Appendix B. Formula Functions and Operators

This list of formula operators and functions includes those used in the examples in Chapter 8, as well as the rest available for use in Airtable formulas. You will see a quick description of each text function, along with the format in which to use it and a simple example.

Text Operators

&

The & operator is used to join, or concatenate, two or more text strings together:

"First name" & "Last name" => "First name Last name"

'\n’

Creates line breaks when placed between other text within formulas:

'\n'

({Musicians} & '\n' & {Comments})

Text Functions

CONCATENATE()

Joins together two or more text strings into one. This is especially useful when you need to combine separate pieces of information, like first and last names or city and state:

CONCATENATE(string1, string2, ..., stringN)

CONCATENATE("New ", "York ", "City") => "New York City"

RIGHT()

Extracts a specific number of characters from the end of a text string. This is particularly useful when you need to isolate specific data, such as the last four digits of a credit card number or the domain of an email address:

RIGHT(string, howMany)
 
RIGHT("slow red fox", 6) => "ed fox"

LEFT()

The LEFT() formula function in Airtable works in a parallel way to the RIGHT() function, except it operates on the opposite side of a text string. This function is handy for when you need to extract or isolate specific data from the beginning of a string:

LEFT(string, howMany)
 
LEFT("John ...