Manage records .md

Edit records like sheets

The hub offers a spreadsheet-like edit experience for Record types that enforce a schema:

  1. Create or select “sheet” on the left navbar. Example

    Organize your sheets using types, similar to creating folders that contain different groups of related sheets. This hierarchical structure is visualized in the left navigation panel — click the + button to create new sheet types and build your organizational taxonomy.

  2. Select the type you want.

  3. Click on “Edit” to add edit rows in the sheet.

  4. Each value in the sheet becomes a selectable option in dropdown menus.

    You can link columns in one sheet to another sheet or registry by specifying the appropriate data type. This creates relational connections that maintain data integrity and enable powerful cross-referencing.

    In the example shown, the time_unit column points to the TimeUnit sheet, which defines the permissible values for this field. This relationship ensures that only valid time units can be selected.

    Column relationships include registry links to predefined registries like TimeUnit or Treatment, ontology references that connect to biological ontologies (bionty.Organism, bionty.Tissue), cross-sheet references that link to records in other custom sheets, and enum constraints that restrict values to predefined lists.

Sheets display field definitions in the headers, showing both field names and their corresponding data types:

Export records as artifacts

Click on “Export to Artifact” to save all records under a type as an artifact.