Formulas (Notion): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
Regel 15: | Regel 15: | ||
<pre> | <pre> | ||
toNumber(prop("Product unit price")) * prop("Number of products") | toNumber(prop("Product unit price")) * prop("Number of products") | ||
+ | </pre> | ||
+ | |||
+ | Also yous this function to convert a date-/time field to Unix Epoch Time: | ||
+ | |||
+ | <pre> | ||
+ | toNumber(prop("Created time")) | ||
</pre> | </pre> | ||
Versie van 18 feb 2023 20:14
concat()
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.
toNumber()
You need 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 yous this function to convert a date-/time field to Unix Epoch Time:
toNumber(prop("Created time"))