[FR] Database: Relation in two way

[stphnmttldrf]

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.

[stphnmttldrf]

Update:

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

[Vivian-appflowy]

@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.
  

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.

[stphnmttldrf]

@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.