AppFlowy-IO/AppFlowy

Fork 0

mirror of https://github.com/AppFlowy-IO/AppFlowy.git synced 2026-03-24 04:46:56 +00:00

[GH-ISSUE #7259] [FR] Database: Relation in two way #3216

New issue

Closed

opened 2026-03-23 21:28:28 +00:00 by mirror · 5 comments

mirror commented

2026-03-23 21:28:28 +00:00

Owner

Originally created by @stphnmttldrf on GitHub (Jan 21, 2025).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7259

Description

Since release 0.5.3 we are able to use a relation from database A to database B.

needed Feature

What i'm looking for is an automatic relation backwards. If i add in database B a relation to one ore more entries in database A, i want in a column in database A all entries in database B with this relation.

Impact

Every user, who uses databases can benefit from this feature. For me it's THE feature for databases and relations.

Additional Context

Example

I have two databases:

projects
notes

In notes i have a relation to projects, to link the project a note is for. In projects i want to see all notes for my project.

Thanks,
Stephan.

Originally created by @stphnmttldrf on GitHub (Jan 21, 2025). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/7259 ### Description Since release [0.5.3](https://github.com/AppFlowy-IO/AppFlowy/releases/tag/0.5.3) we are able to use a relation from database A to database B. ### needed Feature What i'm looking for is an automatic relation backwards. If i add in database B a relation to one ore more entries in database A, i want in a column in database A all entries in database B with this relation. ### Impact Every user, who uses databases can benefit from this feature. For me it's THE feature for databases and relations. ### Additional Context ### Example I have two databases: - projects - notes In notes i have a relation to projects, to link the project a note is for. In projects i want to see all notes for my project. Thanks, Stephan.

mirror

2026-03-23 21:28:28 +00:00

closed this issue
added the
Q4 25

organization

new feature

database
labels

mirror commented

2026-03-23 21:28:29 +00:00

Author

Owner

@stphnmttldrf commented on GitHub (Jan 21, 2025):

Update:

After writing die FR, i found that there is another FR with the same goal: Link

@stphnmttldrf commented on GitHub (Jan 21, 2025): Update: After writing die FR, i found that there is another FR with the same goal: [Link](https://github.com/AppFlowy-IO/AppFlowy/issues/6347)

mirror commented

2026-03-23 21:28:29 +00:00

Author

Owner

@Vivian-appflowy commented on GitHub (Jan 22, 2025):

@stphnmttldrf Thanks for the feedback! This feature sounds useful. To ensure we address your needs, I’m curious about how you currently link projects and notes.

Two databases:

You have separate databases for projects and notes.
Expected: A relation property column links them, so when Column A in the project database is updated, Column B in the note database updates automatically.

2. Projects as a database, notes as docs

Projects are managed in a database, while notes are standalone docs.
You use “@” mentions or the “/” menu to link a note to a project.
Expected: The project database includes a column showing notes linked to that project.

We’d love to hear from you to better address your request! It would also be great if you could share any screenshots to help us better understand your use case.

@Vivian-appflowy commented on GitHub (Jan 22, 2025): @stphnmttldrf Thanks for the feedback! This feature sounds useful. To ensure we address your needs, I’m curious about how you currently link projects and notes. 1. **Two databases:** - You have separate databases for projects and notes. - Expected: A relation property column links them, so when Column A in the project database is updated, Column B in the note database updates automatically. ![Image](https://github.com/user-attachments/assets/9334f261-5463-47c4-97ed-aa2563aaa232) **2. Projects as a database, notes as docs** - Projects are managed in a database, while notes are standalone docs. - You use “@” mentions or the “/” menu to link a note to a project. - Expected: The project database includes a column showing notes linked to that project. ![Image](https://github.com/user-attachments/assets/51afcf91-9761-4190-a1f4-55bd181c23d7) We’d love to hear from you to better address your request! It would also be great if you could share any screenshots to help us better understand your use case.

mirror commented

2026-03-23 21:28:30 +00:00

Author

Owner

@stphnmttldrf commented on GitHub (Jan 22, 2025):

@Vivian-appflowy Thanks for your question.

At the end, both variations sounds like a good idea. But my use case is Version 1:

All Notes in Database "Notes"
All Projects in database "Project"
Click on one project, i see all notes related to this project.

In reality there are more databases related to each other: project, people, institutions, todos and notes. Actually i use Notion (but can't use it anymore because of GDPR and working for public sector) and there i have this feature.

@stphnmttldrf commented on GitHub (Jan 22, 2025): @Vivian-appflowy Thanks for your question. At the end, both variations sounds like a good idea. But my use case is Version 1: - All Notes in Database "Notes" - All Projects in database "Project" - Click on one project, i see all notes related to this project. In reality there are more databases related to each other: project, people, institutions, todos and notes. Actually i use Notion (but can't use it anymore because of GDPR and working for public sector) and there i have this feature.

mirror commented

2026-03-23 21:28:30 +00:00

Author

Owner

@Vivian-appflowy commented on GitHub (Mar 7, 2025):

A request for the version 1 use case from Discord:
for grids, is there the functionality of a two-way relation column? for example if I have a Tasks grid with a Projects relation, can I have the mirror relation in Projects grid which show all Tasks that were assigned to each project?

@Vivian-appflowy commented on GitHub (Mar 7, 2025): A request for the version 1 use case from [Discord](https://discord.com/channels/903549834160635914/905299371485188137/1347270712695586838): for grids, is there the functionality of a two-way relation column? for example if I have a Tasks grid with a Projects relation, can I have the mirror relation in Projects grid which show all Tasks that were assigned to each project?

mirror commented

2026-03-23 21:28:30 +00:00

Author

Owner

@annieappflowy commented on GitHub (Dec 18, 2025):

Supported in the upcoming release (v0.10.7)

@annieappflowy commented on GitHub (Dec 18, 2025): Supported in the upcoming release (v0.10.7)

mirror referenced this issue

2026-03-23 22:19:34 +00:00

[PR #3216] [MERGED] feat: support incremental to update textblock's delta #5624