SeaTable does not fundamentally restrict the type of relationship between tables. However, in some use cases it makes sense to enforce a 1:1 or a 1:n relationship. An inventory management system is a simple example: a projector can only be in one room or with one borrower at any given time. Likewise, a test machine cannot be available for multiple tests at the same time.
New controls for link to other records columns
With SeaTable 2.0, link columns now offer the configuration europe rcs data option “Allow linking to multiple rows”. Enabled by default, disabling the switch means that an entry in the current table can only be linked to a single entry in the linked table. For the two examples above, this means: SeaTable ensures that you don't have to search for the projector among multiple people or in multiple rooms and it prevents the test machine from not being scheduled for two simultaneous tests.
In addition to the configuration option for limiting the number of linked entries , a second new configuration option allows you to limit the type of entries that can be linked . By activating the “Limit links to one view” switch and selecting a view, only those entries in the linked table that are part of the selected view can be linked. If an entry is removed from a view by a filter, it is not available for linking. This new option is crucial when it comes to preventing links between certain entries. Let’s take the test machine as an example again: when the test machine undergoes its annual maintenance, a corresponding flag in the table ensures that it is excluded from the view of available test devices. As a result, it cannot be linked for test use in test planning.