<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> This example database used the length() function to return the number of characters in the Name property. It also uses an if statement to intelligently output “character” or “characters”.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Masked Characters

format(length(prop("Name"))) + " " + ((length(prop("Name")) == 1) ? "character" : "characters")

format(
    length(prop("Name"))
) + 
" " + 
(
    (
        length(
            prop("Name")
        ) == 1
    ) ? 
    "character" : 
    "characters"
)

© Thomas Frank