Naar navigatie springen Naar zoeken springen
An overview of Notion functions.
Concatenate strings, including output from commands. E.g.:
concat("Created: ", formatDate(prop("Time - Created"), "W"))
This probably isn't a very useful example, as it includes a label in the property field - Excellent way to mess up data integrity.
Format is the oppositie of toNumber: Convert something to a string. Example:
slice is like mid$(string,positie,length) in some other languages
slice(string, start-index [, end-index]) as string * start-index: Starting at 0 * end-index (option): Last character to include
# Strings of 9 digits # Remove first 6 digits # slice(format(toNumber((prop("Created time"))/10000),5)
toNumber() for calculations that involve relations: Eventhough the looked-up value might be a number, it isn't as it is a relation. Example:
toNumber(prop("Product unit price")) * prop("Number of products")
Also use this function to convert a date-/time field to Unix Epoch Time: