To configure a Link to another table column, choose which workspace and which table in that workspace you want to link to.
Configuration window
Link field options
#OptionDescription
1Create onlyOnly allows creating new records in the linked table, not selecting an existing one.
2Select onlyOnly allows selecting an existing value in the linked table.
3Single linkOnly allows one link per cell.
4Filter linksFilters available links based on a column value or a shared link.
Sub-option of "Create only": delete the row when the link is deleted. Once checked, deleting a link automatically deletes the linked record, in both directions of the relationship.
Example: a Quotes table contains service lines linked to each quote. With this option enabled, deleting a service line in the quote automatically deletes the corresponding line in the Services table. Every deletion is tracked in the modification history and can be restored from the table's trash.
Warning: deleting the parent row does not delete the linked rows. In the example above, deleting the quote does not delete its service lines.
Automatically assign a collaborator: the default value
In the Default tab of the Link field configuration window, you can choose a default value that automatically pre-fills the field when a new record is created:
Default valueEffect
User IDAutomatically links the created row to the workspace member who created it.
Workspace codeAutomatically links the created row to the workspace itself.
Example: automatically identify a row's collaborator. If your Link field points to the technical Workspace members table (automatically generated for each workspace, listing the members who have access to it) and its default value is set to User ID, every new row created in the table is automatically linked to the workspace member who just created it. This is the recommended way to associate a row with its creator without manual entry, rather than typing an identifier as free text.
Display links in the record view
Once your Link field is created and configured, you can set which view of the linked table it should point to, and choose how links are displayed in the record view.
Configure how links are displayed on a view (e.g. "default", "admin", "user") depending on the data visibility you want to show on that record. This configuration is essential to allow selecting or creating links from the TimeTonic mobile app.
Three display options are available:
Table view
Displays links in table mode to show the most information at a glance. Best for showing many links and many fields in the record view.
Card view
Displays links in card mode, for a clean look showing the essential information. Best for showing a few links and few fields in the record view.
Tag view
Displays links in tag mode, with no extra information. Best for showing many links with no fields in the record view.