The String data type holds and represents text content. Strings can hold nearly any character by default.
You can create a string by wrapping characters within quotation marks "
. This includes numbers, “true/false”, etc. If you wrap characters in quotation marks, you’ll create a string.
"Monkey D. Luffy"
"42"
"true"
Strings can be concatenated, i.e. combined. You can do so with the concat function and with the add operator +
:
"Monkey D. Luffy" + " will be " + "King of the Pirates!"
// Output: Monkey D. Luffy will be King of the Pirates!
concat("Monkey D. Luffy", " will be ", "King of the Pirates!")
// Output: Monkey D. Luffy will be King of the Pirates!
You cannot perform mathematical operations on strings. Notion does not do automatic type conversion, so you’ll need to convert strings to numbers manually.
If a string contains nothing but a number, you can convert it using the toNumber function or the unaryPlus operator +
:
// Invalid: Will throw a Type Mismatch error
add(2, "2")
// Valid
add(2, toNumber("2"))
// Also valid
add(2, +"2")
Comparing Strings
You can compare strings using the equal ==
and unequal !=
operators and related functions.
Good to know: As noted above, Notion formulas do not do automatic type conversion. Therefore, the equal and unequal operators test for strict equality. In JavaScript, this would be done with the ===
operator.
"Monkey" == "Monkey" // Output: true
"Monkey" == "monkey" // Output: false (comparison is case-sensitive)
"Goku" != "Vegeta" // Output: true
Escaping Characters
Some special characters must be escaped with the backslash character \
in order to represented property in a Notion formula.
Character | Escape Sequence |
---|---|
Double Quote "
|
\" |
Backslash \
|
\\ |
Newline | \n |
Tab | \t |
Carriage Return | \r |
Backspace character | \b |
Important notes:
- Double quotes
"
will become un-escaped whenever you re-open and edit your formula. You’ll need to re-escape them every time you make an edit. - Single quotes
'
do not need to be escaped. If you wrap a string in single quotes, they’ll be converted to double quotes the next time you open the formula for editing.
Here’s a reference database that contains all of these escaped characters, which you can duplicate:
