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")
You can compare strings using the equal
== and unequal
!= operators and related functions.
"Monkey" == "Monkey" // Output: true "Monkey" == "monkey" // Output: false (comparison is case-sensitive) "Goku" != "Vegeta" // Output: true
Some special characters must be escaped with the backslash character
\ in order to represented property in a Notion formula.
- 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: