Edit Data Tables
Last updated
Last updated
Data Tables are the primary interface for editing data.
Data Tables are organised as follows based on the Data Model:
Table are Entity Types
Rows are Entities
Columns are Properties
Data are Cells.
A Relationship is a Cell under a Relationship Type Column.
Use Quick Search to navigate to different Tables and create new ones.
LeftClick a Column Heading to sort the Rows based on that Column.
RightClick a Column Heading to configure the property, such as:
Rename column
Edit description
View column identifier
Sort by this column
Hide the column values from the sidebar
Change the order of relationships
Delete column
RightClick a Row to configure the entity, such as:
Delete row
Move row (currently not supported)
LeftClick any Cell, then CTRL + E to create a new Row.
You can mark multiple Rows to perform bulk operations such as removing and filling.
Hold LeftClick + Drag to mark multiple Rows.
LeftClick a Cell, then SHIFT + LeftClick another Cell to mark a range of Rows.
LeftClick a Cell, then CTRL + SHIFT + LeftClick another Cell to unmark a range of Rows.
LeftClick the Row Number Cell to mark/unmark a single Row.
To speed up data entry, you can:
Mark multiple Rows (see above)
Select an unmarked Cell
Click "Fill" in the toolbar to update the marked Rows with the value of the selected Cell.
Unmark the Rows if you want to.
Note: The selected Cell cannot be among your marked Rows.
For Relationships, filling will add all of the Relationships from the selected Cell to the marked Rows. It won't remove any Relationships.
Some cells, such as Attachments (Images, Files), support drag-and-drop from your File Manager so you do not need to hunt down files you already have open.
If you want to drag and drop multiple files across multiple rows on the same column to save time, you can. First Mark Multiple Rows then select your files in the same order and drag and drop to the first cell. The order you marked rows and selected files must match.
If a Relationship already exists, Fill will fail to avoid inconsistent updates. This will result in a partial fill as the Rows before the failure will be updated. Use to unfill those Rows if you want to.
