[Feature Request]: Reference column type

[rockerest]

Description

It should be possible to link a table entry to other documents or other entries in tables.

This is currently only possible (for table entries) by following these steps:

1. Expand the row to the full-size modal
2. Click the "Click to create a linked doc in center peek." link
3. Go back to the table
4. Expand the same entry again
5. This time, the full-size modal has a vertical list of options on the right side. Click the "Copy link" button.
6. Use the copied link as a "Link" type entry in a different table

Not immediately, but eventually, the link is converted to the document title.

A "Reference" type column for tables would basically just alias this process:

1. Column type "Reference"
2. When clicking in the cell to enter a value, you can always just paste the link like before, but a picker also opens.
3. The Reference picker would have some kind of drill-down capability so that table entries could be selected without having to go through the first 5 steps above. That process would be either A) done automatically when an entry is selected or B) already be done transparently when entries are created (i.e., a link to a table entry is always created without having to "Create a linked doc" explicitly).

Critically: references should always update to point to the correct location. If a document is moved elsewhere or the title changes or any other piece of identifying information updates, all of the references to that document (or table entry) should continue to point to the correct item.

Use case

Anyone using tables for more than just one-off / static data. Being able to refer to other documents or entries in other tables is very important for creating a cross-linked knowledge store.

Anything else?

No response

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!

[affine-issue-bot]

Issue Status: 🆕 *Untriaged

*🆕 Untriaged

The team has not yet reviewed the issue. We usually do it within one business day.
Docs: https://github.com/toeverything/AFFiNE/blob/canary/docs/issue-triaging.md

^{_{This is an automatic reply by the bot.}}

[donqu1xotevincent]

Is there any way that we can integrate this issue with our discord community feature request channel? So the feature with more support from the community will be the feature we would prefer to ship first.