Notion
Using Notion as a data source for your Softr app.
Overview
Notion is a versatile tool that combines note-taking, project management, and relational database capabilities. This makes it a more powerful data management solution than simple spreadsheets, allowing you to store all your data in one place and streamline workflows and collaboration.
Using Notion databases for your Softr application, you can easily build Client Portals, Internal tools, and other business apps to:
- Simplify user interaction with an intuitive, easy-to-use portal.
- Limit user access to only the necessary data.
- Provide login security without requiring direct Notion invitations.
- Enable users to submit, edit, and sync data with Notion effortlessly
- Easily gather forms, feedback, and inputs within the application
Connecting to Notion
To create an app using a Notion database, the first step is to add Notion as a data source in Softr. You can do this either through the Data Sources section of the Softr dashboard or by adding a new data source directly to a block within your application.
After selecting Notion as the data source, you’ll be redirected to the Notion Authorization page. On this page, select the workspace and top-level pages containing the databases you wish to connect to Softr.
You can authorize the integration only for Notion workspaces where you are a member.
Once connected, only Notion database pages can be used with Softr dynamic blocks, such as List and Detail blocks.
To finalize the connection, click the "Allow Access" button to grant Softr permission to access your Notion account.
Connecting Softr Dynamic Blocks to Notion
Now that Notion is connected as a data source, you can use it to power new or existing applications in Softr. You can map Notion data to various Softr blocks, such as a List block.
Once you select the Notion database, the pages within that database will display as individual records in your application.
Blocks not supported in: List with upvote button, Calendar, Charts, Kanban, Org Chart, Comment, Map, X(Twitter).
Mapping Fields and Field Types
Once your data source is connected to a block, you can map individual fields to display the desired information.
In Notion, properties are essentially the columns in the database, with each property having a predefined type, such as Files, Status, Date, and more. Similarly, Softr offers a variety of field types to choose from when displaying your data. It's important to select the appropriate field type when mapping fields from Notion to Softr.
For example, in the image below, we’ve mapped a File property from Notion to an Image field type on Softr’s List block to display photos.
You can learn more about Softr field types in the List block overview.
Computed Fields
Most fields that can be edited in Notion are also editable in Softr. However, there are exceptions. Fields that are automatically generated by Notion, such as Rollup, Formula and People can be displayed but not edited within Softr.
The following read-only fields are not supported: Last edited by, Last edited time, Created time, Created by, ID, Button.
Database Relations
The Relation property in Notion is essential for creating a relational database. It allows you to link records from one database to another, enabling seamless display of related information across your boards.
For example, if you have two Notion databases—Clients and Projects—you can add a Relation property to Clients to link it with Projects. This lets you easily display all projects associated with a specific client.
In Softr, you can display Relation fields within a List Detail block and use them in Edit/Add Record Action buttons.
Due to limitations in the Notion API, Relation fields cannot be displayed in List-type dynamic blocks (List, Table, Inbox, etc). As an alternative, we recommend creating a Rollup field based on the Relation field and using that for display.
Conditional Filters Based on Relation
Conditional filters allow you to display specific records based on set conditions. This feature is especially useful when showing related records between databases. For example, if you have a "Client Detail" page, you can display a list of projects related to a specific client.
Using Notion and Softr templates
We don’t offer Softr templates yet. As a workaround, you can use Softr templates by copying data to a free Airtable account or Google Sheets. Then, you can remap app blocks to connect to Notion.