Databases | Notion

When creating a linked view of a database, it’s possible to select as view one of the existing views in the original database.

Modifying the view in a linked database will not modify the view in the original database but if we modify the content or the settings or the properties, it will be modified for the original database and any other linked view where the database is displayed.

If you are in a database shared with other people, and you change a view (for example with a filter or sort), the changes will not apply to the others until you click save for everyone.

If it is not saved, it will only appear with the last modifications filters and sort to the user who made the filters and sort.

A linked database can add views from different databases.

A database can only create views for its own database.

WHEN USER HAVE FULL ACCESS	Linked view locked	Linked view unlocked	linked view page locked and linked view unlocked	Database locked	Database unlocked
lock/unlock	YES	YES	YES	YES	YES
copy link to view	x	YES	x	YES	YES
add/delete views	x	YES	x	x	YES
modify view	x	YES	x	x	YES
move property columns	x	YES	x	x	YES
add properties	x	YES	x	x	YES
delete, modify or view properties	YES	YES	x	x	YES
modify any view View options	x	YES	x	x	YES
view automations	YES	YES	YES	YES	YES
add/delete or modify automations	YES	YES	YES	x	YES
apply/modify filters and/or sorting	YES	YES	YES	YES	YES
after apply/modify filters and/or sorting, save for everyone	x	YES	x	x	YES
change source	YES	YES	x	x	x

<aside> ℹ️ notes:

guest can’t add/delete or modify automations
on linked view locked, it is possible to View options but not modify any (except for Group . sub-items, dependencies, or Load limit, for these, not even view)
when clicking the copy link to view from the original database, the different views in this original database can be selected, for the creation of the new linked database
when clicking the copy link to view from a linked view, it will be possible to select the views from the original database and the selected view from the linked view where the link was obtained
a relation between two databases using the name (page) and name (page) properties from both tables, can be linking items or sub-items or sub-sub-items, etc </aside>

<aside> 💡 NICE TRICK: Converting items of a database into pages and moving them back

Select items of a database, then by drag and drop, you can move them outside the database and convert them into a page itself, the newly created pages will not display the properties, their values, or their sub-items.

If the item had sub-items, they will be moved to a higher hierarchy level in the original database: the sub-items will not be moved to the page containing the newly created pages, unless, they are as well selected for moving.

If the item (now page) is moved again into the database, the properties will be displayed again, showing the values it had before moving it out of the database, and the sub-items will be moved back into the hierarchy to be inside the item.

NOTE that it is different than when converting a page into a wiki, when turning a page into a wiki, if properties are added, and/or values added to them or to the standard verification property if we turn again into a page and then turn again into a wiki, the properties previously created are lost, their values, and as well the possible values in the different entries that the property verification may have had previously.

</aside>