How to Automatically Match Text Fields with Relation Pages in Notion

Reader's Question

Hi, I'd like to ask about an operation in Notion. My database has two fields: A1 (text) and A2 (a Relation property linked to another database). Is it possible that after I fill in the A1 field, A2 automatically matches the content I entered in A1? For example, if I type 20250223 in A1, can A2 automatically search its linked database for a page titled 20250223 and match it?

My Answer

First, it's important to clarify that the Relation property does not have built-in automatic matching capability. You'll need a workaround to achieve this. Let me demonstrate the result first.

In the example below, I'll type 20270809 in the "Text Field" of Database 01 to match the page titled 20270809 in Database 02:

Here are the detailed steps.

Step 1: Create a Relay Database

1. Name this relay database "Database 03" and create a single page inside it called "Relay Page."

2. Set up a default template for both "Database 01" and "Database 02." When a new page is created in either database, this template will automatically activate and link the new page to the "Relay Page" in "Database 03."

This way, all pages in Database 01 and Database 02 will be linked to this "Relay Page."

Step 2: Set Up a Rollup Field

In "Database 01," create a Rollup field that displays all the pages from "Database 02" linked through the "Relay Page."

Step 3: Create a Filter Formula

In "Database 01," create a Formula:

Rollup.filter(current.Title.format()==Text)

Now, when the text you enter in the text field of "Database 01" matches a page title in "Database 02," that page will appear in this Formula field.