Autonumber
Formula Reference
Description (from Formula Reference)
Formula Data Type (from Formula Reference)
Example text
1
1
UPPER()

Makes string uppercase.

Text functions
apples and bananas and cats
2
2
LOWER()

Makes a string lowercase.

Text functions
APPLES AND BANANAS
3
3
LEN()

Returns the length of a string.

Text functions
apples and bananas
4
4
CONCATENATE()

Joins together the text arguments into a single text value.

To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.

Text functions
cool things
5
5
REPT()

Repeats string by the specified number of times.

Text functions
apples and bananas
6
6
TRIM()

Removes whitespace at the beginning and end of string.

Text functions
<- spaces ->
7
7
RIGHT()

Extract howMany characters from the end of the string.

Text functions
apples and bananas
8
8
LEFT()

Extract how many characters from the beginning of the string.

Text functions
apples and bananas
9
9
MID()

Extract a substring of count characters starting at whereToStart.

Text functions
apples and bananas
10
10
FIND()

Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.

Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.

Text functions
apples and bananas
11
11
SEARCH()

Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty.


Text functions
apples and bananas
12
12
SUBSTITUTE()

Replaces occurrences of old_text with new_text.

You can optionally specify an index number (starting from 1) to replace just a specific occurrence of old_text. If no index number is specified, then all occurrences of old_text will be replaced.

Text functions
apples and bananas
13
13
REPLACE()

Replaces the number of characters beginning with the start character with the replacement text.


Text functions
apples and bananas
14
14
T()

Returns the argument if it is text and blank otherwise.

Text functions
apples and bananas
15
15
ENCODE_URL_COMPONENT()

Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: - _ . ~

Text functions
www.example.com/apples and bananas
16
16
' '

Create a line break when inserted between other text in a formula.

Text operators
17
17
&

Concatenate text values into a single text value.


Text operators
18
18
“”

Smart quotes (“”) appear curved and will cause an error in Airtable. Instead, use only straight-lined quotes within formulas.

Text operators
Cannot adjust frozen columns; click to learn more or reset
ENCODE_URL_COMPONENT(string)
TRIM(string)
LOWER(string)
UPPER(string)
MID(string, whereToStart, count)
RIGHT(string, count)
LEFT(string, count)
LEN(string)
SEARCH(stringToFind, whereToSearch,[startFromPosition])
SUBSTITUTE(string, old_text, new_text, [index])
REPLACE(string, startCharacter, numberOfCharacters, replacement)
FIND(stringToFind, whereToSearch,[startFromPosition])
CONCATENATE(text1, [text2, ...])
REPT(string, number)
T(value) — check out this formula!
apples%20and%20bananas%20and%20cats%20
apples and bananas and cats
apples and bananas and cats
APPLES AND BANANAS AND CATS
bananas
s and cats
apples and
28
12
apples and bananas and cats
llamas and bananas and cats
1
apples and bananas and cats are cool.
apples and bananas and cats ! apples and bananas and cats !
apples and bananas and cats
APPLES%20AND%20BANANAS%20
APPLES AND BANANAS
apples and bananas
APPLES AND BANANAS
BANANAS
ND BANANAS
APPLES AND
19
APPLES AND pineapples
llamas AND BANANAS
0
APPLES AND BANANAS are cool.
APPLES AND BANANAS ! APPLES AND BANANAS !
APPLES AND BANANAS
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
cool%20things
cool things
cool things
COOL THINGS
cool things
cool things
11
cool things
llamashings
0
cool things are cool.
cool things! cool things!
cool things
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
%20%3C-%20spaces%20-%3E%20
<- spaces ->
<- spaces ->
<- SPACES ->
->
spaces ->
<- spaces
14
<- spaces ->
llamasaces ->
0
<- spaces -> are cool.
<- spaces -> ! <- spaces -> !
<- spaces ->
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
apples%20and%20bananas
apples and bananas
apples and bananas
APPLES AND BANANAS
bananas
and bananas
apples and
18
12
apples and bananas
llamas and bananas
1
apples and bananas are cool.
apples and bananas! apples and bananas!
apples and bananas
www.example.com%2Fapples%20and%20bananas
www.example.com/apples and bananas
www.example.com/apples and bananas
WWW.EXAMPLE.COM/APPLES AND BANANAS
.com/ap
and bananas
www.example
34
28
www.example.com/apples and bananas
llamasample.com/apples and bananas
17
www.example.com/apples and bananas are cool.
www.example.com/apples and bananas! www.example.com/apples and bananas!
www.example.com/apples and bananas
0
llamas
are cool.
! !
0
llamas
are cool.
! !
0
llamas
are cool.
! !
18 records
Extensions

Alert

Lorem ipsum
Okay