Database

Notion Tip: View All Properties In One Cell

Screen Shot 2020-11-07 at 8.42.36 PM.png

⛺️ Combine All Properties

Notion provides a collection of custom “properties” that database entries can be categorized by. In the following tip, I want to show how a user can consolidate all of these properties into one cell, or “formula” property to create a custom ID. This ID will allow for a minimal database view.

To Combine Notion Properties, The User Must Format All Properties Into Text

Step 1: Create a formula property

Screen Shot 2020-11-07 at 9.09.35 PM.png

Step 2: Inside this property, convert all non-text properties you desire to consolidate into text properties if they aren’t already.

Convert non-text properties to text in Notion:

format(prop(“INSERT NAME OF NON-TEXT PROPERTY”))

Also, a user can customize how a date is displayed …

formatDate(prop(“INSERT NAME OF DATE PROPERTY”), “MM DD YY”)

What are non-text properties?

  • Number

  • Date

  • Checkbox

  • Created Time

  • Last Edited Time

How To Combine Text Properties

Combine each formatted property with a “+” sign.

format(prop(“Date”)) + prop(“Title”)

To add an empty space or divider between each property …

format(prop(“Date”)) + “ “ + prop(“Title”)

How To Add Line Breaks

Screen Shot 2020-11-07 at 9.25.42 PM.png

format(prop(“Date”)) + “\n“ + prop(“Title”)