About This Database

The is a free alternative to Notion charts that shows various content stats in Board & Gallery cards, from the total number of posts published to the number of content ideas you’ve added. Some stats have already been configured for you, but you’re welcome to edit them or add some new ones. This page will help you do both!

<aside> <img src="/icons/info-alternate_yellow.svg" alt="/icons/info-alternate_yellow.svg" width="40px" />

The linked database view of the on the right shows all the Formula properties in the “Display Formulas” group.

These display formulas rely on Rollup properties already set up for you. You’re welcome to edit or delete the Rollup properties, but doing so will break the formulas!

To toggle a display formula on or off, hover toward the top right of any database view, click the 3-dot menu (⋯), click Properties, then toggle the eye icon on or off.

</aside>

Untitled


<aside> <img src="/icons/info-alternate_yellow.svg" alt="/icons/info-alternate_yellow.svg" width="40px" />

If you want posts to show up in your stats, ensure the post in the Content DB is linked to the Content Stats page in the “Stats Link” property. All post templates in the Content DB are linked automatically.

To remove posts from your stats, simply unlink the page from the Relation property.

To see which posts in the are linked to your stats page:

  1. Open Content Stats. (Or scroll to the top of this page.)
  2. Scroll down to the “Content DB Link” dropdown and click it to see the full list.

You can also use the Content DB Maintenance Table to bulk-edit pages.

</aside>

Untitled


<aside> <img src="/icons/info-alternate_yellow.svg" alt="/icons/info-alternate_yellow.svg" width="40px" />

This database has a customized layout. Display Formulas and Rollups are grouped together for better visibility. Posts linked from the also have their own dedicated section.

To expand the Rollups and Content DB Link properties, simply click the dropdowns at the top of this page.

To customize the layout, hover toward the title of this page, then click “Customize layout”. From here, you can add new property groups and sections, as well as set the visibility of different properties.

Note that the visibility of these properties applies only to this full-page view. Click here to learn how to show and hide display formulas in Board and Gallery cards.

</aside>

image.png

image.png


Formula Styling

Some of the formulas in the include stylized display text for Board & Gallery views. This section includes some guidance on how to customize this display text with your own text effects, text colors, and background colors.

You can customize text in formulas using multiple style elements. Be sure to enclose each element in quotation marks. To add another style element, add a comma after the closing quotation mark of the previous one.

Formula

style("Your Text Goes Between These 2 Quotation Marks", "b", "c", "blue", "gray_background")

End Result

Untitled

<aside> <img src="/icons/create_gray.svg" alt="/icons/create_gray.svg" width="40px" /> Text styling

</aside>

<aside> <img src="/icons/paint-bucket_gray.svg" alt="/icons/paint-bucket_gray.svg" width="40px" /> Text colors

</aside>

<aside> <img src="/icons/create_gray.svg" alt="/icons/create_gray.svg" width="40px" /> Text background colors

</aside>

Adding New Formulas

Some formulas and rollups have already been set up for you. You’re welcome to duplicate them and experiment with them to power up your stats database! This section also includes a tutorial and example to inspire your future customizations!

Calculating total posts by platform

Step 1. Create a new Rollup property in the “Rollups” property group at the top of this page.

  1. Set the Relation field to “Content DB Link”.
  2. Set the Property field to “Platform”.
  3. Set “Calculate” to “Show original”.

image.png