Person

Learn about the Person data type in Notion formulas.

The Person data type is specific to database properties that allow for users to be selected or displayed, such as the PersonCreated by, and Last edited by properties. When dealing with a Person data type, you can use the name and email functions to return further information about the users in each field.

name(prop("Created By")) /* Output: "Thomas Frank" */ email(prop("Created By")) /* Output: "info@collegeinfogeek.com" */

Using name and email directly like above will only work on properties that only return one person by default, such as Created by and Last edited by. If you wish to use these functions on Person property, you will either need to target the first item with first, or utilise map to return the name or email for each person added to the field.

prop("Assignee").first().email() /* Output: "info@collegeinfogeek.com" */ prop("Assignees").map(current.email()) /* Output: ["info@collegeinfogeek.com", "ben@collegeinfogeek.com" */

Good to know: The email comes back as plain text, not a link. You would need to use the link function and the mailto: prefix to create a clickable email address.

About the Author

My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas