Product Docs
Home
  • ๐Ÿ‘‹Welcome to NotionApps
  • ๐Ÿค‘Lifetime deal (Now expired)
  • ๐Ÿ‘จโ€๐ŸณHire an expert
  • Basics
    • ๐Ÿ’กConnect Notion
    • โœจCreate an app
    • ๐ŸŒŽShare App
      • ๐Ÿš€Publish
      • ๐Ÿ”—Share App Link
    • ๐ŸกAdd To Home Screen
    • ๐Ÿ—„๏ธManage Workspaces
    • ๐ŸŠSwitch Workspaces
    • ๐Ÿ”ƒReload Data (from app builder)
    • ๐ŸŽReload Data (from app)
    • ๐Ÿค–Automatic Reload Data
  • Customize App
    • ๐ŸŽ๏ธApp Navigation
    • ๐ŸŽจApp Icon, Colour, URL
    • ๐Ÿ”—Custom Domain
      • ๐Ÿ’ฐBuy Additional Custom Domains
    • โž•Add New Screen
    • ๐ŸคนTypes of Screens
      • ๐Ÿ‘€View Items
      • ๐Ÿ‘†View One Item
      • Update One Item
      • ๐Ÿง‘โ€๐Ÿ”งUpdate Items/Update Form
      • ๐Ÿ†•Add New Item/Add Form
    • ๐Ÿ‘ฉโ€๐Ÿ”งCustomize a screen
      • โŒ›Filtering or Sorting Items
      • ๐Ÿ“ฒIn-app Filtering
      • ๐Ÿค–Screen Actions
      • ๐Ÿ“šAdd new component to screen
      • ๐Ÿ™ˆScreen Visibility
    • ๐Ÿ‚Type of Components
      • ๐Ÿ‘“View Data Components
      • ๐Ÿ–Š๏ธAdd/Update Data Components
      • ๐Ÿ“Location Viewer Component
      • Signature Component
    • ๐Ÿ™ˆComponent Visibility
    • ๐Ÿ‘ฉโ€๐Ÿ’ปBarcode/QR Code Scanner
    • โ†ช๏ธForm Submit Redirection
    • โš›๏ธFormulas & Rollups
    • โ†—๏ธRelations
    • ๐Ÿ“„Show Page Content
    • ๐Ÿ–ฅ๏ธDesktop View
  • Users
    • ๐Ÿ”Private apps
    • ๐Ÿ˜ŽCreate Users Database
    • ๐Ÿง‘โ€๐Ÿคโ€๐Ÿง‘Internal/External Users
    • ๐Ÿ˜ŠAdd/Remove users
    • ๐Ÿ™‹Data Restriction
    • ๐Ÿ†•Sign up
  • Integrations
    • Introduction
    • Google Login
  • Crisp Chat
  • Enterprise SSO
  • Frequently asked questions
    • ๐Ÿ‘ฉโ€๐ŸญApp builder changes donโ€™t show up in the final application
    • ๐ŸŽขSome rollup properties do not show up in the app builder
    • ๐Ÿ™†โ€โ™€๏ธGuest users don't show up in the dropdown component
    • ๐ŸซDoes NotionApps provide any discounts for non-profits?
    • ๐Ÿ–ผ๏ธMy images load slowly. How do I improve it?
    • โšกHow do I add new tags to dropdown/multi-select components?
    • ๐Ÿ–‡๏ธHow do I show internal page links in the Show Page Content component?
    • 0๏ธWhy are my rollups on NotionApps showing the value as zero (0)?
    • ๐ŸกHow do I add a Home Page to the app?
    • ๐Ÿ‘ฎโ€โ™€๏ธHow to enable third-party cookies?
    • I signed up using Google but now want to sign up using email/password. How can I do that?
  • Video Tutorials
    • ๐Ÿ†•Create new app
    • ๐ŸŽณConfigure custom domains
    • ๐Ÿ”“Private apps
    • ๐Ÿ”User-Specific data (limit rows based on logged-in user)
  • Use Cases
    • ๐Ÿ‘ฉโ€๐Ÿ’ผClient Portal
    • ๐Ÿ”Member Portal
    • ๐Ÿ›ฃ๏ธField Operations
    • ๐Ÿ—’๏ธTask Tracker
    • ๐Ÿ‘ฉโ€๐ŸŽ“Student Portal
    • ๐Ÿ›Bug Tracker
    • ๐ŸคนOnline Course
    • ๐ŸŽฏCRM & Sales
    • ๐Ÿง‘โ€๐Ÿ’ผEmployee Directory
    • ๐Ÿ’ผBusiness Portfolio
    • ๐ŸŒปCatalogue
    • ๐Ÿคธโ€โ™‚๏ธFitness Center
    • ๐Ÿ‘ฉโ€๐ŸซCoaching
Powered by GitBook
On this page
  • Lists
  • Components
  1. Customize App

Formulas & Rollups

Lists

You can choose to show formula and rollup properties in Lists like View Items Screen, 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 View One Item or 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 help@notionapps.com.

PreviousForm Submit RedirectionNextRelations

Last updated 11 months ago

โš›๏ธ