⚛️Formulas & Rollups

Lists

You can choose to show formula and rollup properties in Lists like List (View Items) screen, List (Update Items) screen, List Component, Page Selector Component, etc.

However, you need to be aware of a limitation:

When you choose a property to view in the lists that is a rollup or formula dependent on a rollup, and if the formula is calculated over more than 25 related pages, Notion provides NotionApps results based on only the top 25 related pages.

For example,

Let's say there are two databases:

• Projects and Tasks.

• Projects has a relation to Tasks.

• Projects has a rollup property that counts the number of tasks linked to a project.

Incomplete Data

If a projectis linked to 30 tasks (> 25),NotionApps will only receive the property value as 25 (incomplete value).

Complete Data

If a project is linked to 10 tasks, NotionApps will receive 10 (correct value).

Components

Rollups & Formulas can be shown in all components.

However, for properties where there might be incomplete data(> 25 related pages), we suggest showing them in the Details (View One Item) or Form (Update One Item) screens.

On these screens, when using a "View Text" component to view the property, you will see a refresh button next to it.

On clicking the refresh button, we fetch the complete property data from Notion.

We are working with Notion to make this experience better. Meanwhile, if you have questions, please reach out to us via our website chat or email us at [email protected].