[Feature Request] ONE to ONE relation, show / hide already linked elements and possible to apply filters

1

Hi,

first I want to thank to the team of NocodDB, it’s really cool to use it. I would have some improvements:

  1. ONE - to - ONE Relation
  • It should be able to filter the entries out, which are already linked to other records
  • It should be possible to have as well to have a predefined filter applied. Example: There is a status column (values: open / closed) and it should be only the entries shown, which have the status open.
2

Thanks @fendle & welcome to NocoDB community!

It should be able to filter the entries out, which are already linked to other records

We thought about this during implementation & decided to go with current approach as in cases where one needs to re-assign often, it will otherwise become a two step process (unlink in one place & link in other). Lot of project management scenarios where reassigning is done often - current method fits in right.

It should be possible to have as well to have a predefined filter applied. Example: There is a status column (values: open / closed) and it should be only the entries shown, which have the status open.

This is possible already. Please read docs here

3

Hi dstala,

thanks, I found with the possiblitiy to use a view.

I would be great, if I could select for each created within a table, a different view from my referenced view and not only 1 for all.