Insert a data table

In your Notebook entry or workflow stage entry, click Insert -> Data Table -> New. 

If you are creating an entry from a Workflow Template, appropriate data tables may already be present.

Search or choose an Assay Result.

Add samples to data tables individually

Choose “Add New Row” and search for and select an entity or batch in the window. Data Tables are designated to capture data against either entities or batches.

Import samples and results into the data table

Create a spreadsheet whose columns match the data table headers, including a Sample column. You can do this either in an external spreadsheet editor (e.g. Excel) or utilize a regular Benchling table.

In your Benchling data table, click Import into data table.

Copy/paste in raw text including the headers or upload a spreadsheet.

Click Next and confirm column matching. Please correct any errors. 

After data is validated, select Import in order to add new rows to your data tables, along with any relevant assay data.

Note: This lets Benchling know which data should be recorded against which sample. The most common values used for matching are sample name/ID or plate well.

Update results in the data table

Create a spreadsheet whose columns match the data table headers (including a sample column).

Choose Update from spreadsheet.

In the import into data table window, copy/paste in your raw text or upload your spreadsheet. Then, click Next and choose the appropriate fields to match with your columns. Afterwards, click Import to update values in the data table.

Note: This lets Benchling know which data should be recorded against which sample. The most common values used for matching are sample name/ID or plate well.

Adding custom columns

To add a one-off field, right-click on any column header. Choose Add Column to the left or right.

After, Right-click on the new column and choose Rename.

Note: The custom column is marked by a STAR (*) to indicate that it is not included in the formal data table schema. To add the column to your table, please contact your Registry administrator . 

View results

Results from data tables will appear on the results tab in the Registry (except for custom columns).

 

Did this answer your question?